Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.