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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Babinsky,

If you hover over each slice , it does show % as well as $.  But you want the % to be what shows up as a label, right?

 

Michele

Babinsky's avatar
Babinsky
Helper I
9 years ago

Hi Michele, you are correct.  I need data labels as % and when hovering the chart as $.  It worked for one pie chart but not the other.

 

Still trouble shooting 

 

Thanks all for any suggestions!

 

Babinsky

  • 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