How to add a target line to your chart


To add a line on your bar chart to represent the target, you will need to pull the target data into the query. If that data doesn’t exist in the data source, you can create a new column using an Add Column step and assign a static value (e.g. 100) that will show as the benchmark for every time period.

A static value will act as your benchmark

Setting the chart type to a Bar Line chart will allow your target line to show up as a line.

Final result

Related Charts Help Articles

See more