Forum Discussion
Solved
Values 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.
I can't reproducte it in my test.
What does the data look like in table? I also see ","(comma) as a decimal point, is there any specific locale configuration in your case? Can you upload the excel for test purpose? Do mask sensitive data before uploading.