Forum Discussion
grayscg
4 years agoAdvocate I
Filtering Slicer Values
So my question is basically this: In slicers, can you filter out values that have already been selected, based on a table. So in this simple example below, I have two slicers that are filtering a...
Seanan
4 years agoSolution Supplier
Hi grayscg
You may find it a little more beneficial to try using a Hierarchy Slicer to achieve this. You can find this by navigating to the three dots and clicking "Get more visuals". I personally used the one by DataScenarios.
You can then add your category and food columns and if a user was to select both fruit and veg, when they untick carrots it will also untick the veg category.
I hope this helps you achieve what you are looking for.
Kind regards,
Seanan