Forum Discussion
Interaction between two Slicers doesn't work well
Hi All,
I have two slicers(S1 and S2) with some visuals on one report , S1(City) and S2(Product), and S1 can control S2 but S2 can't control S1. S1 and S2 can control all other visauls. The interaction doesn't work properly when you unselect a selected item in S1 while there is a selected item in S2 related to this S1 item, and that S2 item will display as selected( will not disappear) but not work as a filter on visuals on the report.
E.g.:
2 cities in S1, C1 and C2
2 products in each city: P11, P12 in C1, and P21, P22 in C2
failed scenario:
in Slicer1, select C1 and C2, then 4 products P11, p12, P21 and P22 display in Slicer2;
in Slicer2, select P11 and P21, and everything works well so far;
then go back Slicer1, unselect C2, in Slicer2 I can see P22 disappears but P21 is still there selected as well as selected P11, and visauls display only P11 data (without P21 data).
by my understanding, after unselecting C2 from Slicer1, all items related to C2 should not be listed in Slicer2 since Slicer1 works as filter on Slicer2. The current result causes confusion on the report.
I am not sure if there's any settings I need to change to make it work properly or it's just a bug.
Thanks!
18 Replies
I can repro the same issue here. I’ve reported it internally and will update here once I get any information from PBI team.
Best Regards,
Herbert
Thanks!
Yep looks like a BUG! Anonymous And if you add more data it seems its cumulative!
Got my interest even more so I tested with my actual data sets and maps and voila!
Can't believe I have not seen it before!
Erin Have you also reported this on this Issues forum?
https://ideas.powerbi.com/forums/360879-issues
I just recently created 2 Issues for the Map Legend (first one is already fixed)
Hope they notice the second one soon... :smileyhappy:
I‘ve got the response from Power BI team. This is by design.
We store previous selections and show them regardless of whether another filter may hide them. We do not want to clear selections based on filter from other slicers, and we are obligated to show any seleted items.
Best Regards,
Herbert
Could the team explain to us why this is by design? By my understanding, if the selection on higher level filter is unseleted, it means the user no longer needs data under that selection hierarchy, and also means the previous selection on lower level filter is not longer needed too.
Thanks
Please refer to my last post for the explanation from PBI team. In this scenario, unselecting on higher level filter should make the previous selection on lower level filter unselected generally. But PBI now stores previous selections and show them regardless of whether another filter may hide them. The team do not want to clear selections based on filter from other slicers, and they are obligated to show any selected items.
Best Regards,
Herbert
Is this bug still here? I also have an issue between two slicer ranges not interacting with each others by defaults. Slicers are in between mode and only if I tell them to visually interact together, they would update otherwise ranges excluded by the first slicer would still show up on the second one. Issue is I use BI Embedded and I can't edit interactions programatically as the API does not support it.
I have a similar issue, not sure if there is any solution till now.
I have a date table and columns - date , Period.
I am using 2 slicers on the same page. Date is used as a range slicer and Period is used as a dropdown.
When I select any period from the dropdown i.e. FY2022, the dates do not filter accordingly.
The interaction between the two slicers is on and both columns are coming from same table.selection in dropdown - 2022, but above date range not updating
