Unrelated Criteria for Conditional Formatting?

[Anonymous]

Hi

I have a matrix with employee names on the row pill and 3 measures on the columns (i.e., sum of hours worked, etc). I have conditional highlighting on the column for sum of hours worked but I also need to exclude the highlighting for certain employees (for example -those employees whose name starts with an 'E').

How can this be achieved?

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could show your expected result here. 

If you want to format employees whose name starts with an 'E', you could refer to the following measure.

Measure =
IF ( LEFT ( SELECTEDVALUE ( 'Table'[Name] ), 1 ) = "E", "green" )

[amitchandak]

@Anonymous , Create a color measure and use that in conditional formatting after using "Field" option

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column