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

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

       

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

        That's not working either.