Forum Discussion

Babinsky's avatar
Babinsky
Helper I
9 years ago

Pie Chart

Hello all, I have a pie chart in Power BI that displays values in $ and I'm looking to display the values in %.     The field is a text field.  Any suggestions on how to convert this value so it di...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Babinsky,

 

To show % on data labels for the Pie Chart, you can follow steps below to set Quick Calc for the Values field of your Pie Chart to "Percent of grand total".

 

1. Right click the Values field of your Pie Chart, and select Quick Calc.

 

 

2. Choose "Percent of grand total" on Quick Calc window, and click OK.

 

 

Regards

Babinsky's avatar
Babinsky
Helper I
9 years ago

Thank you everyone for offering suggestions.  I got the report to work.  However, based on the data fields it does not work consistantly on every data filed, however I have a good point of direction.  Thanks again.

 

- Babinsky

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Babinsky,

     

    Great to hear the problem got resolved! Could you accept the corresponding reply as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards