Constant Line for a Stacked Bar and Line Chart

Question

Hi guys,&nbsp;&nbsp;I've seen this question posted before but I haven't quite seen a solution that fits my needs. I have a stacked bar and line chart, and I'm hoping to add a constant line chart, but don't know how to! Any help is appreciated.&nbsp;&nbsp;Best,&nbsp;&nbsp;Denisse&nbsp;&nbsp;

amitchandak · Answer

Anonymous , Create a measure 
Measure = 10
measure = calculate(average(Table[col]),all(Table))
&nbsp;
and use as a line.
Or use analytics pane
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

anonymous · Answer

Anonymous&nbsp;&nbsp;this will help you:&nbsp;https://www.c5insight.com/Resources/Blog/tabid/148/entryid/803/track-goals-in-power-bi-with-constant-lines.aspx

anonymous · Answer

Hello&nbsp;amitchandak&nbsp;,&nbsp;&nbsp;I tried creating a measure, and it added months where I do not have data for. Also, I wouldn't want the data labels to show for the constant line, would you know how to turn it off?&nbsp;&nbsp;Thanks you,&nbsp;&nbsp;Denisse&nbsp;

anonymous · Answer

Anonymous&nbsp;This option is not available on joint Stacked Bar and Line charts..&nbsp;

amitchandak · Answer

Anonymous&nbsp;, In format section of visualization: under label check, if there customize series. If it is there, then you can switch off the label.&nbsp;

Forum Discussion

Related content

CONSTANT LINE STACKED BAR CHART

Stacked Column Chart Data Labels

Constant line stacked bar chart - Value options

Stacked Waterfall Chart

DAX Formula for Stacked CHart