Forum Discussion
dlopesc04
10 months agoResolver II
Floating point precision problem on cards
My cards started showing values like those in the screenshot below today: This is how the format of the measures is configured: It should just show a 0 I really don't want to go over...
- 10 months ago
Hi dlopesc04
To avoid adding ROUND() to every measure, you can try these options:
- Change the column's data type to Fixed Decimal Number in Power Query. This ensures precision is handled at the source, so measures display clean values (like 0) without individual adjustments. Reload your model after making this change.
- Create a base measure with ROUND and reference it in other calculations. This reduces the number of edits, though it requires updating existing measures to use it.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thanks.
Greg_Deckler
10 months agoCommunity Champion
dlopesc04 I can't replicate this, what version of Desktop are you on?
dlopesc04
10 months agoResolver II
I am on 2.147.1085.0 64-bit (September 2025)
Plus, the data type on the source is Decimal (30,5), meaning, only 5 digits after the decimal point