Color coding with Multiple Colors with Multiple Text in same column

[inglexjc]

I have a table called 'Legal Files' column name is Description_1 (Visual shows Description).

I was able to color code when "Letter Waived" is in the column to show the font as BLUE.  But now it's been asked to keep that AND anytime the word "person" or "WebEx" is used for the font to be RED and "Dispo" to be BLUE. 

When I do Status Color = SWITCH('Legal Files'[Description_1], "Dispo",1, "Letter Waived",2, "Person",3, "WebEx",4)

This doesn't work because there is other text in the column so it's not exactly just the words being used.

How else can I get the text to change color when the column contains those words?

[inglexjc]

We have a winner!  Thank you.

[Padycosmos]

In power query, select the description column, create a new column by example, type out the required word in two or three rows, the required words automatically get filled in. You can use the new column in the SWITCH() condition

[inglexjc]

I'm thinking this isn't going to work.

Error even when I tried Letter Waived instead of LW. (in the raw data it comes over as LW.

I'll have to try something different.

[Padycosmos]

Please check my latest reply. 

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=7veYU1EeO6w

[inglexjc]

@Padycosmos this does not help.  Watching the video it has to do with numbers and doesn't translate to text.  Also in the video the numbes are not in the same Column they are in differnt rows.

I need color coding for TEXT in the same Column.

[Padycosmos]

I understand. Please try changing the format style to Field Value as shown below

[inglexjc]

That's not working either.

[Padycosmos]

In the conditions, you can use the conditions  "Person" || "Webex", 3, "Letter Waived" || "Dispo",1

[inglexjc]

@Padycosmos in the youtube video you sent it's using 

How do I convert this when I'm not using numbers?  What formula should I be using in order to get the conditional formating to work?

[Padycosmos]

I have never tried this with a text column and I do not have sample data at the moment. So you may try changing the conditions as shown below: and use numbers as you have used hitherto.

In the conditions, you can use the conditions

SWITCH(TRUE(),'Legal Files'[Description_1], "Letter Waived" || "Dispo",1,"Person" || "Webex", 2) 

The '||' symbol is in this key  Press Shift+this key twice

[inglexjc]

@Padycosmos 

Unfortunately that didn't work either.

[Padycosmos]

Sorry about that. Please try this.

SWITCH(TRUE(),'Legal Files'[Description_1]= "Letter Waived" || "Dispo",1,'Legal Files'[Description_1]="Person" || "Webex", 2) 

[inglexjc]

@Padycosmos  I tired as a new Measure and as a new Column, both are not working.

As a Column:

As a Measure:

[Padycosmos]

A solution at last. It is a measure

[inglexjc]

@Padycosmos  The data has PPI so I can not share.

What am I doing wrong?

But also notice there is other text in the Column not just the words I'm calling out, so that's part of the problem I'm having.  I was able to create a measure to make when "Letter Waived" is in the text to make it all blue.  But I'm not able to add if "person" or "webex" is there make it red. 

[inglexjc]

@Padycosmos  I tried both of these

Color =

VAR COL = SWITCH(TRUE(),SELECTEDVALUE('Legal Files'[Description_1]= "Letter Waived"||SELECTEDVALUE('Legal Files'[Description_1])="Dispo","Blue",SELECTEDVALUE('Legal Files'[Description_1])= "Person","Red",SELECTEDVALUE('Legal Files'[Description_1])="WebEx","Red")

RETURN

COL

Color =

VAR col = SWITCH(TRUE(),SELECTEDVALUE('Legal Files'[Description_1]= "Letter Waived"||SELECTEDVALUE('Legal Files'[Description_1])="Dispo","Blue",SELECTEDVALUE('Legal Files'[Description_1])= "Person","Red",SELECTEDVALUE('Legal Files'[Description_1])="WebEx","Red")

RETURN

col

[Padycosmos]

This works even if the text contains other values. 

[inglexjc]

@Padycosmos 

Color =

VAR col = SWITCH(TRUE(),SELECTEDVALUE('Legal Files'[Description_1]= "Letter Waived"||SELECTEDVALUE('Legal Files'[Description_1])="Dispo","Blue",SELECTEDVALUE('Legal Files'[Description_1])="Person"||SELECTEDVALUE('Legal Files'[Description_1])="WebEx","Red")

RETURN

col

Still get error.

[Padycosmos · Accepted solution]

Color =

VAR col = SWITCH(TRUE(),CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Letter Waived") || CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Dispo"),"Blue", CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Person") || CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"WebEx"),"Red")

RETURN

col