Stacked Column Chart - Percent of Constant Line

[forti4040]

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)

[amitchandak · Accepted solution]

@forti4040 , 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

[forti4040]

@amitchandak , 
That did the trick! Thank you for the quick assistance