Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello All
I am new to power BI and I am trying to give a % view of some data in a bar chart visual. I have looked at various suggestions on the community but I cannot get it to work. The visual and details of the colums and relevent data is below.
Of the total items 6.7K are classed as yes and 5.5K are closed as no. I want to be able to show those values as percentages. I believe I need to create a measure but no matter what a try I cannot get it to work.
Can anyone assist?
Kind Regards
Ian
Solved! Go to Solution.
You can certainly create a measure. However, if it's a relatively simple '%of grand total' you want to show then click on the caret next to 'Count of %.......' in the Value well and choose 'Show value as' -> % of grand total
You can certainly create a measure. However, if it's a relatively simple '%of grand total' you want to show then click on the caret next to 'Count of %.......' in the Value well and choose 'Show value as' -> % of grand total
Many thanks HotChilli, perfect solution.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |