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...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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
2 years ago

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
    Icon for Super User rankSuper User
    2 years ago

    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