Forum Discussion
Solved
Values not Displaying Correctly
Hi, I am a fairly new user of Power BI. I have a table in Power BI that is displaying some values as per below (-2E-12). I have tried changing the decimal places, looked in the source data, etc. and...
HI Shannon_Trick ,
That's the first thing I would say you should check as per the requirements, If you really need to display these very small values.
Because precision beyond 2 decimal places makes a very little difference in most of the real world scenarios.
Thanks,
Pragati
Shannon_Trick These are exponential values and too small to be able to see . You can multiple these values by a big number like 1 mio to see the exact decmial values.
negi007 , thank you. I do believe the values within that column that display -2E-12 do net out to zero. Is there a way I can format this to display the zero or a small number, without multiplying it?
Shannon_Trick Yes change the deimical number to 2 or 3 as per your requirement, it will then show zero