Forum Discussion
Refresh Slicer Selection
Hi,
I ahve a dataset like this one:
| CATEGORY | AREA |
| A | 1 |
| A | 2 |
| A | 3 |
| B | 4 |
| B | 5 |
| C | 6 |
| C | 7 |
| C | 8 |
| C | 9 |
and two slicers one with CATEGORY and the other one with AREA, so that when I select a specific category I can see in the AREA filter the related values.
The problem is that when I change the filter from one category to another in the AREA filter it remains selected the last filter from another category making blank all the graphs in the page.
Is there any way to refresh the AREA slicer every time a value in the CATEGORY slicer is selected?
Thanks,
Andrea
Not really, slicers selection can only be reset by a user action, either by clicking them or through a bookmark that resets their state. So a workaround you can do is precisely that, enable a button to reset that particular slicer or either force the user to erase whatever is in AREA with an Apply all slicers button (this will cause the user to prepare all the selections first and once they are ready, click on Apply all slicers and the data will get filtered)
4 Replies
Not that I can think of automatically. A possible workaround is to design that slicer as a hierachized slicer, meaning that you will have A > 1,2,3; B > 4,5 ; C > 6,7,8,9
I tried, but in that case I have the problem that if I click on one category all the area are selected and this should not happen; if there is a way to avoid this that solution would be fine.
Not really, slicers selection can only be reset by a user action, either by clicking them or through a bookmark that resets their state. So a workaround you can do is precisely that, enable a button to reset that particular slicer or either force the user to erase whatever is in AREA with an Apply all slicers button (this will cause the user to prepare all the selections first and once they are ready, click on Apply all slicers and the data will get filtered)
Hi arimoldi
You can achieve a similar desired result in 3 ways :1. Using a slicer's "eraser" :
To have this option the header should be "on" :
2. you can add a "clear all slicers" button
3. you can use 1 slicer with hierarchies instead of 2 separate ones:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
