Forum Discussion
Erika_S
Helper I
Helper IConditional 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...
Hi Erika_S
Yes,you can.For example:
Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)
Regards,
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
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Erika_S
Yes,you can.For example:
Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)
Regards,
Erika_SHelper I
Helper ICan 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