Forum Discussion

Erika_S's avatar
Erika_S
Icon for Helper I rankHelper I
7 years ago
Solved

Conditional formatting with more than one condition where values are not numerical?

Hi all, Hope someone could help. Well, i was trying and haven't succeeded yet - to conditionally format columns based on other columns value that is not numerical. So for Example - column 1 - Manag...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Erika_S 

    Yes,you can.For example:

    Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)

    Regards,

  • Erika_S's avatar
    Erika_S
    7 years ago

    Can I colour the backgroudn based on the result in the column, rather than creating new column with value 1 and 2?  Say Colour Manager name - Judy yellow, if name is Judy and Country is spain?

     

    If not possible, this is a solution as well.  :)

     

    Thank you so much,

    erika

Erika_S's avatar
Erika_S
Icon for Helper I rankHelper I
7 years ago

Sounds really good !

 

Could I switch the IF for SWITCH, and use multipple conditions? do I use && if i want to say "this condition and this one"?

 

Sorry if my questions very simple.

 

Thank you for your help! its so helpful.

 

erika

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Erika_S 

Yes,you can.For example:

Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)

Regards,

  • Erika_S's avatar
    Erika_S
    Icon for Helper I rankHelper I
    7 years ago

    Thank you, that works!! :)

     

    erika

  • Erika_S's avatar
    Erika_S
    Icon for Helper I rankHelper I
    7 years ago

    Can I colour the backgroudn based on the result in the column, rather than creating new column with value 1 and 2?  Say Colour Manager name - Judy yellow, if name is Judy and Country is spain?

     

    If not possible, this is a solution as well.  :)

     

    Thank you so much,

    erika