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 in the youtube video you sent it's using 

How do I convert this when I'm not using numbers?  What formula should I be using in order to get the conditional formating to work?

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

I have never tried this with a text column and I do not have sample data at the moment. So you may try changing the conditions as shown below: and use numbers as you have used hitherto.

In the conditions, you can use the conditions

SWITCH(TRUE(),'Legal Files'[Description_1], "Letter Waived" || "Dispo",1,"Person" || "Webex", 2) 

The '||' symbol is in this key  Press Shift+this key twice

 

  • inglexjc's avatar
    inglexjc
    Post Patron
    3 years ago

    Padycosmos 

    Unfortunately that didn't work either.

     

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago

    Sorry about that. Please try this.

    SWITCH(TRUE(),'Legal Files'[Description_1]= "Letter Waived" || "Dispo",1,'Legal Files'[Description_1]="Person" || "Webex", 2) 

     

     

  • inglexjc's avatar
    inglexjc
    Post Patron
    3 years ago

    Padycosmos  I tired as a new Measure and as a new Column, both are not working.

    As a Column:

    As a Measure:

     

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago

    If the data is not sensitive, could you please share the Power BI file, I can try 

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago

    A solution at last. It is a measure

     

  • inglexjc's avatar
    inglexjc
    Post Patron
    3 years ago

    Padycosmos  The data has PPI so I can not share.

     

    What am I doing wrong?

    But also notice there is other text in the Column not just the words I'm calling out, so that's part of the problem I'm having.  I was able to create a measure to make when "Letter Waived" is in the text to make it all blue.  But I'm not able to add if "person" or "webex" is there make it red. 

     

  • 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

     

  • inglexjc's avatar
    inglexjc
    Post Patron
    3 years ago

    Padycosmos  I added a ) at the end.

    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
     
    But now getting error that "Too many arguments were passed to the SELECTEDVALUE function. The maximum argument count for the function is 2.
  • 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]),"LetterWaived")||CONTAINSSTRING(SELECTEDVALUE('LegalFiles'[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
    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