Forum Discussion
Constant Line for a Stacked Bar and Line Chart
Hi guys,
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.
Best,
Denisse
5 Replies
- amitchandak
Super User
Anonymous , Create a measure
Measure = 10
measure = calculate(average(Table[col]),all(Table))
and use as a line.
Or use analytics pane
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Hello amitchandak ,
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?
Thanks you,
Denisse
- amitchandak
Anonymous , In format section of visualization: under label check, if there customize series. If it is there, then you can switch off the label.
Anonymous
this will help you: https://www.c5insight.com/Resources/Blog/tabid/148/entryid/803/track-goals-in-power-bi-with-constant-lines.aspx
