Constant Line in Line and Stacked Column Chart

[Anonymous]

Hi Guys,

I am looking to implement a constant horizontal line in my line and stacked column chart. I currently have both line (right axis) and column values (left axis), when I try to pull the constant line data in, it adheres to the right axis,. However I'd like to use it as a target line against my column values and hence it should be measured against the left axis instead. Is there any way I can go about this?

Thanks in advance!

[Anonymous]

Hi @Anonymous ,

Check the below thread:

https://community.powerbi.com/t5/Desktop/Add-a-constant-line-on-a-Line-and-Stacked-bar-charts/td-p/781333

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , You can create a measure that returns constant line and you can add that to clustered/stacked line chart.

Or you can use analytics pane to do that

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

[Anonymous]

Hi,

Unfortunately the Analytics pane is not available for me for that particular chart. As for the measure, would I put it in Column values or Line values? As I would like the line to adhere to the column y-axis. 

Thanks!