Forum Discussion
Issue with two slicers for the same table
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.
Thanks for the response YukiK!
I'm having a bit of trouble visualizing this. Are you saying there would be two separate Order tables in this case, one for each OrderType? Can I bring the data of two separate tables together for a table visual?
No. You'd have the table you origianally had, which I believe contain both OrderType1 and OrderType2.
To visualize what you want, you will place two table/matrix visuals, each has either OrderType1 or OrderType2 column. And set the visual interactions between these tables and slicers so that OrderType1 slicer will affect only the visual that contains OrderType1, and do the same for OrderType2.
I created a demo file here for you to download: PBI file
Hope that makes sense.
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.
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.