Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi, is it possible to have one slicer 'clear selections' on another when a different selection is made?
EG, if i have a slicer with a choice of 'cars' or 'motorbikes', and then a 2nd slicer with dropdown options of different types, at the moment if i select a car type, like 'hatchback', but then change from 'cars' to 'motorbikes', nothing is shown on my page because obviously there aren't any hatchback motorbikes!
I want my 2nd slicer always to default to 'all' once the first is changed - is this possible?
I'm also in need of this functionality. Is any work being done on it?
Hi @thorpyuk , did you found a solution for this? I am also having the same issue.
Hi @thorpyuk
I believe is what you are looking for -
Please mark this as a solution if this answers your query.
Thanks
Radhika
Hi Radhika
Thanks a lot for the tip. Much appreciated!
However, the issue still remains: the selection on the 2nd slicer does move according to the selection on the first slicer. However, the selection in the 2nd slicer does not default to the top element in that 2nd slicer. This is the functionality that I need.
Thanks again
BernardNie
Hi @Anonymous
Could you please clarify a bit more, may be using an example please?
Thanks
Radhika
Hi Radhika
I have the following (very simple) dataset
Slicers:
Step 1: Select a Country = "Australia"
Step 2: Select the Country = "UK"
So, every time a Country is changed, the Quarter filter must reset to Quarter 1.
Any ideas?
Thanks a lot!
BernardNie
Hello all
Does anyone know of an update on this?
I have a similar problem:
When I select a Country and a Quarter (e.g. Q3), I get the correct results from Sales.
However, when I select a new Country, the slicer with the Quarter does not reset to Q1. This is the behaviour that I need. The interaction should be immediate, so I do not think that I can trigger a bookmark.
Any ideas, please? Are there any 3rd party slicer visualizations that may address this issue?
Thanks a lot!
BernardNie
@thorpyuk, unfortunately, that is not possible at this point of time, slicer keep the selection and it doesn't reset if you select the value from the different slicer, it is how slicers currently work, I think there is an idea on this on ideas forum, do vote for it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi! do you know if this is still true now? thanks a lot in advance
@thorpyuk , refer if this can help
https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
Hi Amitchandak, no because i have other slicers on the page (EG date) that i don't want to clear, so a bookmark is no good...
Is it not possible to clear only one?
Hello,
Did you manage to find a fix for this?
I am currently trying to reset the zoom slider with a button/option but keep my remaining filters the same. Or at least default the zoom slider when i change one of the other filters.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |