Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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's avatar
    HotChilli
    Icon for Community Champion rankCommunity 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Many thanks HotChilli, perfect solution.