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 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

Need Help

2 Replies

  • 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