Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional formatting based on multiple conditions

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 ab...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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:

     

    your result will be like this:

     

     

     

    Hope this is what you are looking for.

     

    Thanks

    Raj

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

unfortunately this is not possible.

Currently it's not possible to correlate the color of a conditional formatting to the return value of a measure.

 

But hopefully this will change someday, but in the meantime you maybe find this https://dataveld.com/2018/07/16/use-svg-images-in-power-bi-part-3/ or some earlier blogs posts helpful. 

 

Regards

Tom