Forum Discussion
inglexjc
Post Patron
Post PatronColor coding with Multiple Colors with Multiple Text in same column
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...
- 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")RETURNcol
inglexjcPost Patron
Post PatronWe have a winner! Thank you.