Forum Discussion

Nivas538's avatar
Nivas538
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Slicer Interaction with table based on another slicer value

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Nivas538
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      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's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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