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 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.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |