Filter reset while interacting

[DiegoCorriendo]

Hi,

I have a problem with filters in a particular casuistry I will try to replicate in order to clarify it.

I have two filters related, lets say Countries and Football Teams that I need to filter my data.

It is a typical 1:N relationship where each team belongs to only one country.

The problem here is that if I filter a Country for (typically) reduce the Team list and select the desired one easily.

And then I change the Country filter in order to select another team, information became incompatible because as shown in images, Chelsea is not an Spanish team and displayed data is null.

Is there any way to clear the Team filter when the Country filter is interacted or solve the problem in another way?

PD: Also, the selected value in Teams filter stays as a 'ghost value'

and it dissapear from list while deselected.

making data compatible again and being able to show the values.

Thanks in advance.

Regards.

[v-juanli-msft · Accepted solution]

Hi @DiegoCorriendo 

As tested, it is a default behavior.

I find a workaround with Hierarchy slicer from market place.

Edit the interaction between Hierarchy slicer and default slicer as below

select "ignore" on default slicer when clicking on the Hierarchy slicer

Then when you reselect from "country" slicer, the team slicer will be reset.

Best Regards
Maggie

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