Forum Discussion
ChrisPBI
Advocate III
Advocate IIIValues with many zeros
Hello everyone, I connected Power BI with an Excel spreadsheet. When I display the values, strange numbers after the decimal point occur. E.g. in Excel a sum is 800, but Power BI shows it...
In my opinion, it is actually a develoment item regarding "float is approximate". Check Floating point inaccuracy examples and Floating point.
Thanks for sending me the pbix. In this case, try to change the "GGE in kg CO2e" from "decimal number" type to "fixed decimal number". Check the difference in Data types in Power BI Desktop.
MattAllington
Community Champion
Community Championyour data looks like it is not rounded. Try formatting the number with 1 or zero decimals
ChrisPBIAdvocate III
Advocate IIIHi,
my values are rounded to two numbers after the decimal point.
Such as:
| 25,65 |
| 15,30 |
| 3,60 |
| 0,45 |
But this results in Power BI in:
I have no idea why.
Thanks for helping.
Regards,
Chris