Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Way to format decimal places of values in tool tips?

Hi, 

 

In my dashboard, I have metrics that require many decimal places in the metrics themselves, or they will round to inaccurate values in certain cases. 

 

On the visual themselves I'm changing the decimal places to be what I want to display.  

 

However, in the tooltop it's showing the values to the decimal value defined in the metric themselves instead of the # of decimal places specified in the data fabel formatting. 

 

Is there a way to make the tooltip display a desired # of decimal places without changing the # of decimal places in the metric itself? 

 

For example, below the visual is set to 1 decimal places - but the underlying metric of 'GP % - all years' is 4 decimal places and the tool tips is displaying all 4. 

 

slacey7070_0-1629902731471.png

 

 

 

Thank you kindly, 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

factly, it can not be set to 1 in tooltip if your underlying data have 4 decimal places. 

if you really need 1 decimal place in tooltip, you have to create a custom tooltip, otherwise the default tooltip will always be in the same format as the underlying data.

- you can try this to create a custom tooltip,

1. create a report tooltip page, then set its format

vxiaotang_0-1630043014728.png

2. create the measure having same value, then put it into the report tooltip page

vxiaotang_1-1630043167344.png

3. change the Tooltip of your visual, 

vxiaotang_2-1630043257289.png

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

result

vxiaotang_4-1630043705037.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

factly, it can not be set to 1 in tooltip if your underlying data have 4 decimal places. 

if you really need 1 decimal place in tooltip, you have to create a custom tooltip, otherwise the default tooltip will always be in the same format as the underlying data.

- you can try this to create a custom tooltip,

1. create a report tooltip page, then set its format

vxiaotang_0-1630043014728.png

2. create the measure having same value, then put it into the report tooltip page

vxiaotang_1-1630043167344.png

3. change the Tooltip of your visual, 

vxiaotang_2-1630043257289.png

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

result

vxiaotang_4-1630043705037.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , Do the formatting in column/Measure tool and check. Once you click on a column or measure that should be available

 

Data Format New Rib.png

Anonymous
Not applicable

Is that the only way? 

 

When I round in that spot, I often get some incorrect percentages due to rounding once the data starts getting sliced and diced. Which is why I'm trying to keep the metrics themselves as more decimal places, and then only change the displayed %'s in the visuals themselves. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.