How to make slicer filter another slicer...so frustrating

[kman42]

I have two slicers, one is a list of names and the other is a list of forecasts for each person. I also have a measure: Forecast Slicer Filter = countrows('forecasts'). The two tables are related 1 to many people to forecasts. When I select a name from the first slicer, it filters the second. If I select a forecast and then change the first slicer, the forecast slicer will keep the originaly selected forecast and add the forecasts for the newly selected person. E.g.:

Name slicer has Bob selected -->Forecast slicer will show three forecasts for Bob. If I select Bob's Forecast 1 then a graph updates correctly. This is the correct behavior.

Now select Jill from Name slicer-->Forecast slicer will show the three forecasts for Jill but also shows Bob's Forecast 1 as selected. I can select one of Jill's forecasts and it updates correctly, but since I selected Jill in the Name slicer, I don't want Bob's forecasts to show up in the Forecast slicer.

What am I doing wrong? Thanks!

[mattiasdesmet · Accepted solution]

I don't think that behavior can be avoided when working with the default slicer.

When you switch selection in slicer 1, the already selected value in slicer 2 remains selected. When you deselect it in slicer 2 it will disappear from slicer 2 as well.

Another visual might behave slightly different, eg. I tested Filter by PowerViz from the AppSource and this does remove visually the selection for the original slicer 1 selection - https://powerviz.ai/contactus