Show Percentage on a Stacked Bar Chart (NOT 100% Stacked Bar Chart)

[Anonymous]

Dear all,

I would like to show percentages instead of amounts on a stacked bar chart. Having browsed extensively on this forum and the internet, I can only find solutions for 100% stacked bar charts, not what I am looking for. I have added links below for my sample PowerBI file. Any help would be much appreciated. Thank you very much!

Link to sample PowerBI file 

Link to sample Excel database 

Regards,

Joyce C.

[MFelix · Accepted solution]

Hi @Anonymous ,

You cannot change the data labels types from the charts, the only visualizations that allows that change is the donut/pie chart, all others return the data labels based on the calculation you have in this case the sum o Number O/S.

You can try and find a custom visual on the appsource or create your own with charticulator.com

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Dear Ashish, @Ashish_Mathur 

When I apply the solution to my real data with a similar structure, I get "100%" instead of the percentages I want to calculate, don't know what went wrong. I have attached my PBI file with sensitive data masked. I shall be grateful if you could help. Thank you very much!

Link to PBI file 

Link to Excel database 

Regards,

Joyce C.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = divide([Total Slow Proj No],CALCULATE([Total Slow Proj No],ALL('Aging Table')))

Hope this helps.

[Anonymous]

Thank you. It works.

[Ashish_Mathur]

You are welcome.

[Anonymous]

Thank you for your help.

[Ashish_Mathur]

You are welcome.

[MFelix · Accepted solution]

Hi @Anonymous ,

You cannot change the data labels types from the charts, the only visualizations that allows that change is the donut/pie chart, all others return the data labels based on the calculation you have in this case the sum o Number O/S.

You can try and find a custom visual on the appsource or create your own with charticulator.com

[Anonymous]

Dear all, I have added images to my post. 🙏