Conditional formatting, 3 text options

[Anonymous]

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 snippet of the table. I would need yes values to be highlighted green, in transit light green, and no in Red. 

Would i need to create a number column for each? If so, how would i do that? 

Thanks! 

[v-luwang-msft]

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:

Step 3, configure like below:

Final get:

About color code ,refer this link :https://www.computerhope.com/htmcolor.htm 

To learn more details ,refer: 

Conditional Formatting with a Text Field in Power BI

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[Fowmy · Accepted solution]

@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" )

[Syndicate_Admin]

Thanks! It worked for me 🙂