Forum Discussion
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 as 800,0000000001.
Does enybody know this problem?
Thanks and Regards,
Chris
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.
11 Replies
your data looks like it is not rounded. Try formatting the number with 1 or zero decimals
Hi,
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
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.
Hi Eric,
no idea how to upload the Excel her ..
Regards,
Chris
I think M.A. is right about rounding. In my experience what displays and what is actual does vary.
Depending on where these values come from - if they are calculated then the round function in the Dax/SQL is key...but if they are from your source then you have a couple options:
*Are you sure in excel that you have explicitly formatted the column? - do that.
*Then in Power BI, in the data setting of the table/query - format it to 2 decimal places there too....
Of course if it is your source; and if you are going to be receiving new data via excel repeatedly then reformatting that column each time is a bit of a hassle so hopefully the Power BI setting will suffice.....
