Constant Line in Line and Stacked Column Chart

Question

Hi Guys,&nbsp;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!

amitchandak · Answer

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
&nbsp;
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

anonymous · Answer

Hi,&nbsp;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.&nbsp;&nbsp;Thanks!

anonymous · Answer

Hi&nbsp;Anonymous ,&nbsp;Check the below thread:&nbsp;https://community.powerbi.com/t5/Desktop/Add-a-constant-line-on-a-Line-and-Stacked-bar-charts/td-p/781333&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

Forum Discussion

Constant Line in Line and Stacked Column Chart

3 Replies

Related content

Stacking Data Columns

Stacked Column Chart Data Labels

Need a stacked clustered column chart

CONSTANT LINE STACKED BAR CHART

100% stacked column chart and constant line