Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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/
Hi @Fowmy,
Unfortunately I am strugling to recreate this. Can you please give me a brief walkthrough?
Many thanks,
Yev
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |