Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MuppetyMe
Helper I
Helper I

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? 
1 ACCEPTED SOLUTION
Kedar_Pande
Super User
Super User

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).

View solution in original post

2 REPLIES 2
MuppetyMe
Helper I
Helper I

Thank you @Kedar_Pande, that did the trick!

Kedar_Pande
Super User
Super User

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).

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.