Values not Displaying Correctly

[Shannon_Trick]

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 I'm unable to get a few to display an actual value. Does anybody know why this might be happening?

[Pragati11]

Hi @Shannon_Trick ,

These values are quite small so you will have to check by increasing the decimals on them.

Just try giving your column Decimal Number format and set them to 15 decimal places. I tried as follows based on the sample you shared and can see the actual values:

Thanks,

Pragati

[Shannon_Trick]

@Pragati11, thank you. I tried that and it does display a number. However, given I have a lot of other values that don't require 15 decimal places it's not the best solution. Perhaps I need to review whether I really need this data displayed. I could remove these three, I think.

[Pragati11 · Accepted solution]

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]

Thank you all so much for the help. 🙂

[negi007]

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

[Shannon_Trick]

@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? 

[negi007]

@Shannon_Trick Yes change the deimical number to 2 or 3 as per your requirement, it will then show zero