The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
currently I have several filters in cascade but when I set the filters and then change them I stay with the previous filters, how can I make that when I click on the first filter the others remain empty?
I am also facing the same issue. The intention is to clear filter of Slicer B based on the selection in Slicer A.
Say Slicer A has Country
Slicer B has Cities
Summarized Data is Say Population
The idea is that cities should empty/clear if one moves from USA to India.
Any help on the same will be appreciated.
Did you find any solution?
Use a hierarchy slicer instead of separate filters.
Hi @Syndicate_Admin ,
What you want seems it is not match the logic. let's see, If you want to filter by multiple slicers. You select the first slicer and prepare to select the second slicer, as you would expect, when selecting the items in the second slicer, the items just selected in the first slicer will be deleted.
So at the beginning of selecting slicer, a button clicked to empty all the slicers. create a bookmark in the page and update the bookmark by all the slicers are empty status.
Refer:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try editing the interactions (ie disable them) and see if that gives you the desired result.
User | Count |
---|---|
81 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |