Deselect a slicer based on hierarchical parent

[Anonymous]

Hi all, this may be a very simple solution but I haven't been able to find anything by searching. I have relatively simple hierarchical data such as:

District A contains schools B and C

District D contains schools E and F

There is a one-to-many relationship between districts and schools, which is also enforced in the underlying data. I have tried several approachs to creating dropdown slicers, but the problem I always run into is this:

1. I select district A. Visuals are updated with district A sums.

2. I select school B. Visuals are updated with school B sums.

3. I open the first dropdown and select district D (which unselects district A because single select is on). School B is still selected in the 2nd dropdown, so no results are shown. The behavior I would like to see is that school B is deselected and the visuals update with District D sums.

4. If I then open the 2nd dropdown and deselect School B, it disappears from the select list - so the referential integrity enforced by the relationships is working, but not until the user deliberately interacts with the slicer.

So what I am looking to do is to deselect or reset the 2nd dropdown whenever the selection in the first one is changed. In other words, when I change the selected district, clear out the school dropdown. I realize I can use a bookmark to clear out all selections but what I would really like to see is the hierarchy enforced automatically when a selection is changed.

Any insight on how I might go about doing this?

TIA,

Will

[v-yuta-msft · Accepted solution]

@Anonymous,

I'm afraid the built-in slicer doesn't have this feature, as a workaround, you may use hierarchy slicer instead.

 

Reference: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.