Forum Discussion

MuppetyMe's avatar
MuppetyMe
Helper I
1 year ago
Solved

Conditional formatting ICONS based on multiple conditions

Attempting to apply conditional formatting icons to a column based on values in another column. Inspired by this post: Conditional formatting based on multiple conditions , I created a measure: 

 

Lead Status Condition = MAXX(Leads,
    If(Leads[Status] = "New"&& Leads[Lead Age]>=30, 1,
        IF(Leads[Status] = "Working"&& Leads[Lead Age]>90,2,
            If(Leads[Status] = "New"&& Leads[Lead Age]<30,3
))))
 
Ideally 1 and 2 would show a red flag icon, 3 would show a green checkmark. Unfortunately, it seems the conditional formatting options have changed since the post and I'm not sure how to make this work with icons - or if this is even the correct way to go about it. Any thoughts or advice? 
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    Revised DAX Measure:

    Lead Status Condition = 
    MAXX(
    Leads,
    SWITCH(
    TRUE(),
    Leads[Status] = "New" && Leads[Lead Age] >= 30, 1,
    Leads[Status] = "Working" && Leads[Lead Age] > 90, 2,
    Leads[Status] = "New" && Leads[Lead Age] < 30, 3,
    BLANK() // Optional: to handle cases that don't meet any conditions
    )
    )


    Steps:

    1. Click on the table where you want to apply conditional formatting.
    2. In the Fields pane, select the column you want to format, click on the dropdown arrow, and select Conditional formatting > Icons
    3. Choose the measure Lead Status Condition for the conditional formatting rule.
      assign icons based on the numerical values returned:
      1: Assign a specific icon (e.g., red circle).
      2: Assign another icon (e.g., yellow triangle).
      3: Assign another icon (e.g., green checkmark).

2 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Revised DAX Measure:

    Lead Status Condition = 
    MAXX(
    Leads,
    SWITCH(
    TRUE(),
    Leads[Status] = "New" && Leads[Lead Age] >= 30, 1,
    Leads[Status] = "Working" && Leads[Lead Age] > 90, 2,
    Leads[Status] = "New" && Leads[Lead Age] < 30, 3,
    BLANK() // Optional: to handle cases that don't meet any conditions
    )
    )


    Steps:

    1. Click on the table where you want to apply conditional formatting.
    2. In the Fields pane, select the column you want to format, click on the dropdown arrow, and select Conditional formatting > Icons
    3. Choose the measure Lead Status Condition for the conditional formatting rule.
      assign icons based on the numerical values returned:
      1: Assign a specific icon (e.g., red circle).
      2: Assign another icon (e.g., yellow triangle).
      3: Assign another icon (e.g., green checkmark).