Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
Does any of you know if it's possible to show both values AND percentage in a stacked bar chart? As an example, in the chart below, I'd like it to show 28% next to 30M, and 72% next to 79M.
Thank you in advance!
Indeed , It is possible with some Power BI measures magic. @apohl1 @v-cazheng-msft @amitchandak
I created 3 measures:
1. Count = COUNTROWS('Table')
2. Count % =
This is very elegant!
Thanks, it worked!
Hi @apohl1,
Currently, we are not able to display values along with percent in a Stack bar chart at the same time. You may consider these solutions.
1 Voting for similar ideas in Power BI ideas: https://ideas.powerbi.com/ideas/search-ideas/?q=values%20and%20percent%20%20stack%20bar%20chart
2 Take the solution from the super user d_gosbell in this post: https://community.powerbi.com/t5/Desktop/Stacked-Bar-Chart-Percent-AND-Count/m-p/632510
3 Consider Tootip, the solution from v-cherch-msft in the same post above
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Thank you for your reply! At least it confirms what I'd like to do is currently not available. I will vote for this idea to be implemented hopefully soon.
@apohl1 , this video has one solution , check if that can help
Change Data labels
https://www.youtube.com/watch?v=un4PkoGF3YM
Thanks for your message, but I'd like to show value and percentage at the same time, so unfortunately not a solution.
Thanks anyway!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
17 | |
16 |
User | Count |
---|---|
34 | |
21 | |
19 | |
18 | |
11 |