Forum Discussion
Tooltip numbers
Hi all ,
I need one help
can you help me correcting tooltips number format to zero decimal places.
is there any way to handle this
Regards
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst
Hello govind_021
There is no way to handle this. bcz, there is no option to restrict the tool tip decimal point in Power BI as of now.
If you want to bring this feature please submit your Idea here: Fabric Ideas - Microsoft Fabric Community
Microsoft may bring up this feature in future based on no of votes getting for this idea.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
4 Replies
- burakkaragozSuper User
Hi govind_021 ,
Thanks for reaching out. You can definitely format the tooltip values in your Power BI pie chart to show zero decimal places. Here's how you can do it:
Option 1: Format the Measure
If you're using a measure to calculate the percentage, you can apply formatting directly in DAX:
Formatted Percentage = FORMAT([YourMeasure], "0%")
This will round the percentage to the nearest whole number and display it with a percent sign.
Option 2: Use Tooltip Formatting in the Visual
- Select your pie chart.
- In the Visualizations pane, go to the Format section.
- Expand the Data labels or Tooltips section (depending on your version).
- Look for Value decimal places or Display units.
- Set Decimal places to 0.
Option 3: Adjust in the Data Model
If the percentage is calculated in Power Query or the data model, you can round it using:
Rounded Value = ROUND([YourValue], 0)
Then use this field in your tooltip.
For more details, check out the official documentation on Data labels and tooltips in Power BI.
Let me know if you're using a custom tooltip page or need help with a specific DAX formula.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
- suparnababu8Super User
Hello govind_021
There is no way to handle this. bcz, there is no option to restrict the tool tip decimal point in Power BI as of now.
If you want to bring this feature please submit your Idea here: Fabric Ideas - Microsoft Fabric Community
Microsoft may bring up this feature in future based on no of votes getting for this idea.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!- MasonMASuper User
Hi govind_021
suparnababu8 is correct! For the percentage in tooltips, it's by default rounded to 2 decimal places.
To make the tooltip consistent with data label, the workaround solution is to create one 'tooltip page' and format the percentage either through Power BI UI as below or DAX. Then use it in your Visuals.
- DataKnightOsakaNew Member
Thanks! This sounds a good option!