Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I needed a hierarchical filter system where (filter f1 filters f2 and f3) & (f2 filters f3). All filters filter two charts on the same page. I found a good solution to this on stackoverflow using a filter table each possible combination of the filters and a unique identifier. However, when f2 has values selected when f1 gets changed, f2 keeps those values even though they are not apart of the relevant filter.
As you can see below, if I select South, then Texas (see step1), and then West (see step2), Texas stays selected. This is a problem because since there are no values for Texas in the data with West, the chart goes blank.
Is there a way I can get the State filter to reset when the Region filter changes? Thank you
Hi @bclrk ,
I am afraid that you couldn't do it currently, but you can reset all slicers with a button. You could refer to this document: https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
And you could post your idea here, maybe it will be a feature of Power BI in the future.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |