Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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" )
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" )
@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"))
User | Count |
---|---|
143 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |