Forum Discussion
Unrelated Criteria for Conditional Formatting?
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?
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" )
2 Replies
- amitchandak
Super User
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")) - v-eachen-msft
Community Support
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" )
