How to change label of a stacked column chart to Percent but not of grand total?

[jovendeluna21]

Hello,

Any help on how to change label of a stacked column chart to Percent but not of grand total?

I have here below graph and I want the data labels to be in percentage but not of a grand total but based on total of month. For example each month, the category should total 100% each month. I want to retain the visual to be stacked column instead of 100% stacked column so I can still see the trend of spend over time. Thank you!

You can find here the pbix copy

https://drive.google.com/file/d/1sKCzmXUeBNOEH3lbMRkpV8g8slS_HIHI/view?usp=sharing

[v-xiaoyan-msft]

Hi @jovendeluna21 ,

I don't quite understand your needs, can you show the output you expect?

Do you want to present the content as shown but don't want to use a 100% stacked column chart?

Or do you want to use another way, maybe this similar case can help you?

Clustered Column chart that shows % of row total by x-axis value 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[jovendeluna21]

Yes, you are right that I want to present the content as shown but don't want to use a 100% stacked column chart. I want to show still the trend month over month. Something like below image

[amitchandak]

@jovendeluna21 , As far as I know, the power you can not have a label on another column than what you use. So what we do we create % of subtotal column and use that in visual

[jovendeluna21]

how can I create % of subtotal column?