Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Thank you kindly,
Solved! Go to Solution.
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
2. create the measure having same value, then put it into the report tooltip page
3. change the Tooltip of your visual,
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
result
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.
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
2. create the measure having same value, then put it into the report tooltip page
3. change the Tooltip of your visual,
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
result
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.
@Anonymous , Do the formatting in column/Measure tool and check. Once you click on a column or measure that should be available
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |