Forum Discussion

Bluemoose's avatar
Bluemoose
Regular Visitor
2 years ago

PowerBi showing weird value

Hi all, 

 

I'm just having this weird issue, Power Bi is not showing up the correct value.

 

I've tried changing the format to Decimal Number and it didn't work. 

 

Formula and weird data value shown below: 

 

 

Thanks 🙂 

 

5 Replies

  • Hi Bluemoose
    It seems that there is a result coming back that's less than 0.
    You can try, it will round the result to 2 decimals

     

    Budget Variance = ROUND([Forecast] - [Current Budget, 2)

     

     Joe

    • Bluemoose's avatar
      Bluemoose
      Regular Visitor
      Thanks Joe but it didn't work, i think it might be an issue from the data set
  • Hi Bluemoose 

    The number format indicates that there are many digits after the decimal point. This means that the formula might not be working correctly, possibly due to an issue with the model or something not being sliced properly. I recommend removing variables from the matrix and trying to debug the formula.

    To proceed further, we need to see the file. If you can remove any sensitive and confidential information, then save it to a cloud drive and share the link.


    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

    • Bluemoose's avatar
      Bluemoose
      Regular Visitor

      Thanks Ritaf 

       

      Definitely due to some many digits after the decimal points which I did try to round it off to two decimals and also tried manipulating the data set, still didn't work. 

       

       

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi Bluemoose 
        As I mentioned earlier that seems some calculation/model problem.
        Need to see the file to assist further.

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly