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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.