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 ...
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
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)
Then in conditional formatting how would I apply the value of the ___value variable?
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