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.

pbi_106's avatar
pbi_106
Helper I
4 years ago

Thanks for the example, YukiK, that does help me follow.

 

I'm still holding out hope that there's another solution that allows users to apply these slicer filters to the same table visual without getting in each other's way, but it's good to know, worst case scenario, that there is still another option.

YukiK's avatar
YukiK
Impactful Individual
4 years ago

Glad to be some help! I believe you could separate OrderTypes columns in to separate tables and make them so that they don't have relationships between them. That way, you might be able to do what you want, however, that may or may not be an issue in other visuals for your analysis.