Conditional formatting based on multiple conditions

[Anonymous]

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

 

[Greg_Deckler · Accepted solution]

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)

[Greg_Deckler · Accepted solution]

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)

[Anonymous]

Got it!  I had to change to Rules.  Thanks

[Anonymous]

Then in conditional formatting how would I apply the value of the ___value variable?

[Maddy99 · Accepted solution]

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