Forum Discussion
Exclude data based on Slicer
huguest solution is attached. you have to create standalone region table to achieve this.
You have to also think of if multiple region select , and how you want it to behave. I just assumed that user will have one region selected, if more than one region selected then it will use that as all regions selected.
A hacky way I can think of to do this quickly is to have two slicers, and set one slicer to only fitler the pie chart on the left, and the other slicer to only filter the pie chart on the right.
Definitely would be cool to do this dynamically without having to have two slicers, but can't think of a way at the moment (doesn't mean it's not possible).
huguest solution is attached. you have to create standalone region table to achieve this.
You have to also think of if multiple region select , and how you want it to behave. I just assumed that user will have one region selected, if more than one region selected then it will use that as all regions selected.
Wow, this is perfect. I just have to change the slicer to only allow a single selection (which is what it should have been). Thanks a lot for you rapid assistance.
