Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bclrk
Advocate II
Advocate II

Unselect filter when other filter changes

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.

step1step1step2step2

Is there a way I can get the State filter to reset when the Region filter changes? Thank you

1 REPLY 1
v-eachen-msft
Community Support
Community Support

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors