Slicer Interaction with table based on another slicer value

[Nivas538]

We have below requirement

1)When we select Attended as "YES" in slicer and change the date value in slicer ,table grid should be displayed as per both the filters.

2)When we select Attended as "No" in slicer and change the date value ,table grid should be displayed only as per the selected value in Attended filter and it should ignore date slicer.

Slicers

Table

Thanks,

Sri

[Anonymous]

Hi @Nivas538 ,

I don't find a way to solve this problem using DAX (even I really want), but I have a workaround, a trick to make this I think.

If you have better ideas please tell me.

Just using the bookmark, please create 2 blank buttons in the positions of "Yes" and "No" of your Attended slicer.

And I think now you know how to do it.

In the bookmark 1, we have Table1, Date slicer1 and Attended = "yes", that's easy to understand

In the bookmark2, we have Table2 which is the same as Table1, Date slicer2 and Attended = "no", and then using the Edit Interaction to disable the sync between Date slicer2 and Table2.

Thanks.

Aiolos Zhao

[Nivas538]

Hi @Anonymous ,

Thanks for quick response. I think We can't filter the slicer values in the  Bookmark. And also we've another five more slicers.

For Ex: After creating  bookmark  with these , we have Table1, Date slicer1 and Attended = "yes", 

   if user wants to Switch select Attened=no or he wants to slice the values from another slicer for that Date Range it won't result expecting values in the table.

thaks,

Sri.

[v-lili6-msft]

hi  @Nivas538 

For Ex: After creating  bookmark  with these , we have Table1, Date slicer1 and Attended = "yes", 

   if user wants to Switch select Attened=no or he wants to slice the values from another slicer for that Date Range it won't result expecting values in the table.

If you change to 'no', other slicers still work well, why they could not work in your side?

Regards,

Lin