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...
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
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