Forum Discussion

Wilk89's avatar
Wilk89
Frequent Visitor
2 years ago
Solved

How to color values ,00

Hi, Is it possible to color values ​​with a note that does not contain ,00?
Need Help
  • sanalytics's avatar
    sanalytics
    2 years ago

    Wilk89 

     

    You can use the below pbix file for complete solution.

     

    https://dropmefiles.com/ONEvY

     

    Regards

    sanalytics

    If it is your solution then please like and accept it as solution

     

     

     

     

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi,

Use this formula and put in a conditional formating:

Color = IF( MOD([SumValue],1)=0,"RED")


The final result should be this:

 

Wilk89's avatar
Wilk89
Frequent Visitor
2 years ago

I tried but I get an error on my database.

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    This error indicates that the measurement has an incorrect data type. Choose format as Decimal Number.