Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago
Solved

Color 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...
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago
    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
inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago

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's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago
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