Data labels as % of total in stacked column chart

[YevD]

Hello,

I was wonderig if there is a way to display % of total instead of actual value in data lable - similarly to using 'value from cell' in Excel charts. For example, I would like my chart in the  pbix file (link below) to show 18% ($10M/$56M) and 82% ($46M/$56M) in data labels while still showing the column total as total dollar amount of $56M. If possible, showing both $ and % would be even better.

You can see that I've attampted to at least show it in the tooltip, but looks like my measure is not correct either. Some help with that formula would also be greatly appreciated.

https://1drv.ms/u/s!AgeVqxpmuh7I9QLQ966gtP5d6czR?e=JgWZtF

Thank you!

[Fowmy · Accepted solution]

@YevD 

I tried using Calculation Groups and got the desired results, please check the attached file and let me know if you need to understand how it was done.

[YevD]

Hi @Fowmy, it's been a year since I posted this, but wanted to thank you again for your solution! I finally got to working with claculation groups and was able to replicate. I did run into a bit of an issue where labels which contain 0 were displaying incorrectly. I was able to get around it with suggestion in article below where same problem is tackled.

https://www.sqlbi.com/tv/displaying-measures-as-percentages-in-power-bi-charts-unplugged/

[YevD]

Hi @Fowmy,

Unfortunately I am strugling to recreate this. Can you please give me a brief walkthrough?

Many thanks,

Yev

[YevD]

Hi @Fowmy ,

This is exactly what I was looking for. If you don't mind, I'd love some help with understanding how it was done. I started reading up on the calculation groups but haven't been able to re-create this yet. It seems like I should start using them for most if not all of my measures.