Forum Discussion

inglexjc's avatar
inglexjc
Post 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
Post Patron
3 years ago

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

This works even if the text contains other values. 

 

  • inglexjc's avatar
    inglexjc
    Post 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
    Solution Sage
    3 years ago
    This works
    Color =
    VAR col = SWITCH(TRUE(),
    CONTAINSSTRING(SELECTEDVALUE(Orders[Category]),"Fur")||CONTAINSSTRING(SELECTEDVALUE(Orders[Category]),"Off"),"Red",CONTAINSSTRING(SELECTEDVALUE(Orders[Category]),"Tech"),"Yellow")
    RETURN
    col
     
     
  • Padycosmos's avatar
    Padycosmos
    Solution 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