Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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)
Proud to be a Super User!
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.
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
Proud to be a Super User!
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)
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |