Forum Discussion
Values with many zeros
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.
Hi Eric,
no idea how to upload the Excel her ..
Regards,
Chris
You can use any web storage, such as onedrive, dropbox. Please upload the pbix along with the Excel file.
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 believe my prior post is not correct. One is able to control the precision / decimal place count in a visual. I believe this could be the original post question.
Highlight the table/field on the right most Field page that has too many decimal places, then go to the ribbon's Modeling tab - and up there change the Decimal Number default from 'Auto' to 0
