Forum Discussion

ginnielee's avatar
ginnielee
New Member
11 months ago
Solved

Percentage in Pie Chart

When I hover over the pie chart, it shows the value and the percentage beside it. Am I able to adjust the decimal place of the percentage? 

Eg: 
Name John
Size 35 (20.35%)

Was the tooltip. can I adjust the percentage to 20.4%?
Thank you!

  • Hi ginnielee 

    There is currently no option to adjust decimal place of an auto-generated tooltip. Only the labels can be adjusted. Your other option is to use a page tooltip.

     

8 Replies

    • ginnielee's avatar
      ginnielee
      New Member

      That adjusts the value in the pie chart, but i want to adjust the label. 

        I want to change the (22.56%) to (22.6%)

      • PBI_Consultant's avatar
        PBI_Consultant
        Frequent Visitor

        Hi ginnielee , 
        Follow the steps shown in the image to achieve the desired outcome. If this solution works for you, please consider liking and accept it as accepted. Thanks

         

  • Hi ginnielee 

    There is currently no option to adjust decimal place of an auto-generated tooltip. Only the labels can be adjusted. Your other option is to use a page tooltip.

     

  • ginnielee  Hey,
    I will follow below steps to solve your problem.

     

    Step 1: Click on the paint roller icon (Format icon) under the 'Visualizations' pane to open format settings.

    Step 2:  Locate 'Data Labels' in the drop-down menu.
    and You might find the option for 'Data label' settings such as 'Decimal Places' here. Set the number of decimal places to 1 to display percentages like 20.4%.

     

    Step 3: - Scroll down in the Format section until you find Tooltips and Here, you might need to adjust settings related to how data is displayed, ensuring your adjustments to decimal places in data labels affect tooltips as well.

    Step 4: If all above steps does not work then you can follow further steps.

     

    - If the above doesn't work, you might need to adjust the field format itself.
    - Click on 'Data' view in the left menu (looks like a table icon).
    - Find the percentage field in your dataset being used and select it.
    - Go to the 'Column tools' tab across the top and set 'Decimal Places' to 1 as needed. This might apply to calculated metrics.

     

    Thanks

    Harish M

  • v-priyankata's avatar
    v-priyankata
    Community Support

    Hi ginnielee 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    HarishKM danextian FBergamaschi Thanks for the inputs.

    I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

     

    • v-priyankata's avatar
      v-priyankata
      Community Support

      Hi ginnielee 

      I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

      • v-priyankata's avatar
        v-priyankata
        Community Support

        Hi ginnielee 

        Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.