Forum Discussion
Stacked Column Chart - Percent of Constant Line
Hello All,
I have a stacked column chart that spans several months across the X axis. I've also got a constant line I've added with a "max" project loading. I'd like to automatically label each column somehow with the percentage loading vs the constant line. Is this possible? Example below where I've manually labeled one column, but idea would be to have each column labeled.
The 37% reflects how far over the constant line that month is loaded.
(37% = (144 / 105) - 1)
Anonymous , You can create a measure
M1= 37
or
M1 = calculate(Sum(Table[Value])/Sum(Table[Value2]) , all())
and use that as a line in stacked line visual and remove the secondary axis
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
2 Replies
- amitchandak
Super User
Anonymous , You can create a measure
M1= 37
or
M1 = calculate(Sum(Table[Value])/Sum(Table[Value2]) , all())
and use that as a line in stacked line visual and remove the secondary axis
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
amitchandak ,
That did the trick! Thank you for the quick assistance