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

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

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

      Please check my latest reply.