Solved: Conditional formatting based on multiple condition... - Page 2

Anonymous · ‎07-16-2018

Hi,

In matrices, is it possible to have conditional formatting based on more than one rule?

Ie based on column value (cabin) and aggregation value sum(seats remaining)

(Note I am not talking about formulaic statements - this is to do with formatting cells)

Eg

If Cabin = 'Business' and Seats between 10 and 40 then format Green

If Cabin = 'Economy' and Seats between 10 and 40 then format Orange

etc etc

Cabin	Seats	Colour
Business	30	Green
Business	10	Orange
Economy	30	Orange
Economy	10	Red

Anonymous · ‎07-17-2018

Hi @Anonymous

Can you try this?

Create a measure

Condition = MAXX(Ex_Format, 
   IF(Ex_Format[Cabin]="Business"&& Ex_Format[Seats] >10, 1,
        IF(Ex_Format[Cabin]="Business"&& Ex_Format[Seats] <=10,2,
            IF(Ex_Format[Cabin]="Economy"&& Ex_Format[Seats] <=10, 3,
                IF(Ex_Format[Cabin]="Economy"&& Ex_Format[Seats] >10 && Ex_Format[Seats]<=40, 2)))))

Here, 1 -> Green. 2-> Orange, 3-> Red.

and then do the conditional formatting like this: