topic Constant Line in Line and Stacked Column Chart in Desktop

Constant Line in Line and Stacked Column Chart

Anonymous — Wed, 10 Jun 2020 03:49:27 GMT

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!

Re: Constant Line in Line and Stacked Column Chart

amitchandak — Wed, 10 Jun 2020 04:28:23 GMT

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

Re: Constant Line in Line and Stacked Column Chart

Anonymous — Wed, 10 Jun 2020 05:22:48 GMT

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!

Re: Constant Line in Line and Stacked Column Chart

Anonymous — Thu, 11 Jun 2020 07:13:05 GMT

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!