Forum Discussion
Conditional formatting based on multiple conditions
I have a table where each row has a status. The status can be one of five: 1-Submitted, 2-Approved, 3-Rejected, 4-Scheduled, 5-Created. I would like to conditionally color the background row color based on the value of the Status column. So have a blue for Submitted, Green for Approved, Red for Rejected, Yellow for Scheduled, Black for Created.
When I got into Conditional Formatting for the table, it only lets me use 'Count' of a value. What am I missing here or is this not possible? Thanks
You will want a numeric measure like this:
Measure 5 = VAR __value = MAX(Table11[Column2]) RETURN SWITCH(TRUE(),__value = "Submitted",1,__value = "Approved",2,__value = "Rejected",3,__value = "Scheduled",4,__value = "Created",5)
go to your table.
right click for conditinal formatting.
format by rule.
select here you new measure wich only get numbers as result.
and then make the good rules wich numer gets wich color. maybe play a little bit with this combination
4 Replies
You will want a numeric measure like this:
Measure 5 = VAR __value = MAX(Table11[Column2]) RETURN SWITCH(TRUE(),__value = "Submitted",1,__value = "Approved",2,__value = "Rejected",3,__value = "Scheduled",4,__value = "Created",5)
go to your table.
right click for conditinal formatting.
format by rule.
select here you new measure wich only get numbers as result.
and then make the good rules wich numer gets wich color. maybe play a little bit with this combination