How to color values ,00

[Wilk89]

Hi,

Is it possible to color values ​​with a note that does not contain ,00?

[sanalytics · Accepted solution]

@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

[Wilk89]

I tried but I get an error on my database.

[_AAndrade]

Hi,

Use this formula and put in a conditional formating:

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

The final result should be this:

[Wilk89]

I tried but I get an error on my database.

[_AAndrade]

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