How to conditional format a text (string, not number)

[Anonymous]

I have a field showing Left, Right as text, is that possible to conditional format the words?  So when it is left, red, when it is right, yellow.

thank u!

[dax · Accepted solution]

Hi @Anonymous ,

You could use below measure to create conditional formating(you could use color code to replace color name) 

Measure 3 = switch(MIN('Table (3)'[color]), "left", "red", "right", "#f5dc6c")

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

Not directly, but easy enough to do with a helper column.

1. Create a new column either in Power Query or in a Calculated Column. The following is DAX for a calculated column:
   1. FormatColor = IF(Data[Direction] = "Left","Red","Yellow")
2. I used a Table visual for this. Put the [Direction] field in the Values section. (Directions is what is returning Right or Left)
3. CLick the little dropdown arrow for Direction and select Conditional Format, Font ColorFormat by Field Value
4. Base it on the FormatColor field and summarize by First (latter not relevant but you have to set it to something)