Forum Discussion

hk106's avatar
hk106
New Member
4 years ago
Solved

Issue with two slicers for the same table

Hi,   I have a table, Orders, with columns for OrderType (has to be 1 or 2) and Total.   I've added two slicers.  One that filters by OrderType of 1, and another that filters by OrderType of 2.  ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi hk106 ,

     

    According to your description, even if you use the Edit interaction function, you cannot achieve the results of two filters in the same table at the same time. This is because the visual image of the table presents the merged set of multiple filters instead of the intersection.

     


    Best Regards,
    Henry


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

YukiK's avatar
YukiK
Impactful Individual
4 years ago

I believe this behavior is expected. You can workaround this by creating 2 tables instead of 1 table, each has OrderType of 1 and the other has OrderType of 2.

 

And then set the visual interactions so that each slicer affects appropriate table accordingly. To change visual interactions, go to "Edit Interactions" under "View" tab.

 

Hope that helps.