Forum Discussion

Shannon_Trick's avatar
Shannon_Trick
New Member
5 years ago
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...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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's avatar
Shannon_Trick
New Member
5 years ago

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

Shannon_Trick_0-1600698218608.png

Pragati11's avatar
Pragati11
Super User
5 years ago

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's avatar
    Shannon_Trick
    New Member
    5 years ago

    Thank you all so much for the help. 🙂