Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Format based on Text - NOT COUNT - How to Remove Count

I'm trying to utilize the following method to colorize background of cells based upon the status TEXT that's in them. I found a video that demonstrated this method, but in the video the person was ab...
Need Help
JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hey Anonymous ,

 

how about writing a calculated column that represents the color you want for that row/value.

Proper explanation can be found here .

 

In short

  1. Open the conditional formatting pane
  2. Format by Field Value
  3. Choose your calculated column and the summarization First Value
  4. Finish#

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I've attempted to use the exact format shown in the hyperlink provided however, it's saying the syntax is incorrect/cannot find the field name I'm using (however, it's clearly correct when you look below at the field name).. Looked for a way to click within the [ ] brackets and auto-insert the field to try to resolve but could not find a way to do that - very, very new to PBI any expansion on how to get this working via this method or other - greatly appreciated... JosefPrakljacic TIA

    Note: Originally it was just named the default: Table1 (3) (3rd table) as shown in my orig pics but it seemed to hate the Table Name too, so I renamed the table to "STATUS".. now it hates the Field Name! :smileysad:

     

    ColorDAX = SWITCH(TRUE(),STATUS[Sent Received]="Complete", "#FF7F00", STATUS[Sent Received]="In-Progress", "#2AAAFF", STATUS[Sent Received]="Not Started", "#7F55FF")

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      6 years ago

      Hi Anonymous,

       

      are you trying to do this in a measure?

       

      Try it as a calculated column.

       

      WHen you use a measure you are missing the row-context and you there fore need a function that will work as a iterator. In your case I would jsut put the code in a calculated column ;-) 

       

      BR,

      Josef 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        JosefPrakljacic  yes, measure is the only thing I've really toyed w/ as a newbie.

        Not sure how I would add a new calculated column yet and retain the same exact look (that client wants to see).. Is it as simple as would be done with Excel? Click on the existing "Sent Received" column, then insert a new one (click "New Column" from ribbon, name orig field "Sent Received1" and name new column "Sent Received".. then a basic formula/function "=Sent Received1" to carry over the contents.. then add the other script within the scripting bar area? Finally hide the orig field called "Sent Received1"? Stab in dark here.. If you could include exact steps to achieve what you're suggesting I'd greatly appreciate it (and learn from it) =-)