Forum Discussion

DiegoCorriendo's avatar
DiegoCorriendo
Frequent Visitor
6 years ago
Solved

Filter reset while interacting

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.

  • 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.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    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.