Forum Discussion
Condition Formatting
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?
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
1 Reply
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