Forum Discussion

Sajid02's avatar
Sajid02
Icon for Helper I rankHelper I
2 years ago

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

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Sajid02
Icon for Helper I rankHelper I
2 years ago

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