Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |