Forum Discussion
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
- FBergamaschiSuper User
Hi ginnielee
yes you can. Select the visual, go the Format pane and then
Visual on top
Detail labels
Options
Values
and here adjust the decimal places
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- ginnieleeNew 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_ConsultantFrequent 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
- HarishKMSuper User
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-priyankataCommunity 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-priyankataCommunity 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-priyankataCommunity 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.