Forum Discussion

govind_021's avatar
govind_021
Super User
1 year ago
Solved

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

  • 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

    1. Select your pie chart.
    2. In the Visualizations pane, go to the Format section.
    3. Expand the Data labels or Tooltips section (depending on your version).
    4. Look for Value decimal places or Display units.
    5. 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.

  • 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!

    • MasonMA's avatar
      MasonMA
      Super 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.