Forum Discussion
Conditional formatting, 3 text options
Is there any way to set conditional formatting rules for a whole table based on text fields? I have looked and can only create conditional formatting rules that are based off numbers. This is a s...
Anonymous
Create the following measure, choose conditional formatting, Background , Select Field Value and choose this meaure:CF = VAR __V = MAX ( table[hardware assigned] ) RETURN SWITCH ( TRUE (), __V IN { "Yes", "In Transit" }, "Green", __V = "No", "Red" )
Anonymous
Create the following measure, choose conditional formatting, Background , Select Field Value and choose this meaure:
CF =
VAR __V =
MAX ( table[hardware assigned] )
RETURN
SWITCH ( TRUE (), __V IN { "Yes", "In Transit" }, "Green", __V = "No", "Red" )
Thanks! It worked for me 🙂
