Solved: Condition Formatting

Anonymous · ‎03-31-2019

Hi,

Need Help.

Wondering if i can clolur Tag number in the below table by Float=Ros-Dos (A,B,C,D)

the float = ros-dos from Float..

how can i colour Tag number as the category of float or float=ros-cos?

Anonymous · ‎04-01-2019

Hi @Anonymous ,

I'd like to suggest you add a measure to get calculate result and based on this result to return specific color. After these steps, use this measure as conditional formatting fields value:

Color =
VAR temp =
    SUM ( T1[A] ) - SUM ( T1[B] )
RETURN
    IF (
        AND ( temp >= -37, temp < -17 ),
        "Red",
        IF ( AND ( temp >= -17, temp <= 0 ), "Yellow", IF ( temp > 0, "Green", "Gray" ) )
    )

Regards,

Xiaoxin sheng

View solution in original post

Anonymous · ‎04-01-2019

Hi @Anonymous ,

I'd like to suggest you add a measure to get calculate result and based on this result to return specific color. After these steps, use this measure as conditional formatting fields value:

Color =
VAR temp =
    SUM ( T1[A] ) - SUM ( T1[B] )
RETURN
    IF (
        AND ( temp >= -37, temp < -17 ),
        "Red",
        IF ( AND ( temp >= -17, temp <= 0 ), "Yellow", IF ( temp > 0, "Green", "Gray" ) )
    )

Regards,

Xiaoxin sheng