Forum Discussion
MuppetyMe
1 year agoHelper 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: ...
- 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:- Click on the table where you want to apply conditional formatting.
- In the Fields pane, select the column you want to format, click on the dropdown arrow, and select Conditional formatting > Icons
- 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).
Kedar_Pande
1 year agoSuper 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:
- Click on the table where you want to apply conditional formatting.
- In the Fields pane, select the column you want to format, click on the dropdown arrow, and select Conditional formatting > Icons
- 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).