Forum Discussion
How can I show % values in a bar chart visual?
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
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
2 Replies
- HotChilli
Community Champion
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
- AnonymousNot applicable
Many thanks HotChilli, perfect solution.