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 able to select: Conditional Formatting > Background Color it comes up with "Based on field": "Count of MyFieldName"

I don't want the "COUNT" - how do I turn this off so I can simply select MyFieldName as is done in this video link (4:48)?

 

If I can turn off COUNT then I should be able to proceed w/ setting my parameters that will work in conjunction w/ my New Measure (shown in the code window)..

I notice before choosing the "Conditional Formatting" item, there's a list of items and the only thing checkmarked is "Don't Summarize"... (COUNT is NOT checked).. Options available in list are:  Remove Field, Rename, Move, Conditional Formatting, Don't Summarize, First, Last, Count (Distinct), Count, New Quick Measure, Show items w/ no data, New Group.

As mentioned the ONLY thing checked is "Don't Summarize" - I tried unchecking it to see if it would remove Count but it won't uncheck..

Images attached to show what I see..

I don't understand WHY the middle says "Summarization" too, if "Don't Summarize" is obviously already check-marked!?  If that dropdown is clicked there's only 2 options: "Count" and "Count (distinct)"

Video referenced: 

https://www.youtube.com/watch?v=Y8xmJgVjdZs

 

 
Progress Colorization = 
VAR ProgressType = SELECTEDVALUE('Table1 (3)'[Sent Received])
RETURN

SWITCH(TRUE(),
ProgressType = "Complete", 1,
ProgressType = "In-Progress", 2,
ProgressType = "Not Started", 3
)
Need Help

8 Replies

  • 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