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

Pragati11's avatar
Pragati11
Super User
5 years ago

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