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.
ChrisPBI - what is the base datatype of your columns? The seem to be some rounding issues if you use Decimal Number datatype - I always set the datatype of my source to Fixed Decimal Number and then when creating measures I change the datatype back to Decimal Number.
So I can reproduce this. If one uses one of the chart visuals, using a number field - that is then optioned for the average (the default is typically the sum) - - the resulting value when you hover your cursor over a spot - - I am seeing many decimal places. And I don't see any way to limit that.
I happen to use a line chart but am assuming any chart with a number that gets optioned to be calculated as part of the visual - - I am not seeing any option to control that number format.....
It is kind of crazy to see: 23.33333333333333 so unless I am missing an aspect in the existing interface this probably should be a development item.....