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:    ...
  • Kedar_Pande's avatar
    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).