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.
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