To highlight Card value which is not matching with table value after slicer selection

[Sajid02]

Hi Team , 

We have a table in which we have 2 columns in one column we have the name of team members and on other column we have the name of person who has worked on that task.

We want a column so that we have the name of the person who has not worked on that task.

Either show / highlight the name of the Team members from column 1 (in which we have all team members name) or show all the names who has not worked on the task.

I am stuck on this.

Please help me at the earliest.

Thanks and Regards.

Sajid

[v-zhengdxu-msft]

Hi @Sajid02 

Maybe you can try this:

I create a set of sample data:

And create a measure:

Color1 = IF(MAX('Table (2)'[%value])=1,"red")

Right-click the [name] column > Conditional formatting > font color

Select the Field value in the format style > choose the measure[color1] in the What field should we base this on?

The result is as follow:

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sajid02]

Hi @v-zhenbw-msft 

Thanks for the revert!

May be it is misunderstood. What i require here is to show the value out of multiple values coming in all resource card after slicer selection  eg through snip 

What i actually want that , if any task is selected through slicer , multiple user's are assigned to it , some of them are filling details against task and SOME ARE NOT. I want to show those users in next card who are NOT filling details .

Like in this case :  2 user's are there one is Chioma and second is Louise . Chioma is filliing details so his name is coming in table but louise name is not coming. So want to show Loiuse name in next card.  Tried the dax as well i.e 

Resource Selection =

IF(ISFILTERED('DW Celoxis_TimeEntries'[resources]),

 ALLSELECTED('DW Celoxis_TimeEntries'[resources]), VALUES('DW Celoxis_TimeEntries_User'[name]))
But it returning Chioma name , not louise name as shown in screenshot.  Might it help in understanding the situation.

Many Thanks