I have a bar chart, but needed to create a horizontal line through the chart to show the benchmark.

[Anonymous]

I have a bar chart, but needed to create a horizontal line through the chart to show the benchmark.   I can't find how to do this at all.  Any ideas?  Must be some way to do it.

[HotChilli · Accepted solution]

Analytics function.  Next to Fields and Format

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may also use Line and stacked column chart.Create a measure and use it in line values to get the horizontal line.

Regards,

Cherie

[HotChilli · Accepted solution]

Analytics function.  Next to Fields and Format

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane