Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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

Need Help

Fowmy
4 years ago
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" )

v-luwang-msft

Community Support

4 years ago

Hi Anonymous ,

Try like below:

step1,create a new measure:

Hardware =
IF (
    MAX ( 'Table'[Hardware Assigned] ) = "Yes",
    "#1E8449",
    IF ( MAX ( 'Table'[Hardware Assigned] ) = "In Transit", "#82E0AA", "#C70039" )
)

Step2, Click the visual column,conditional formatting-Background color: