Forum Discussion

aoberholzer's avatar
aoberholzer
Frequent Visitor
2 years ago

Related slicers

I am just starting out my PowerBI journey and have been running into something very frustrating related to slicers. I am wondering if anyone out there in the PowerBI community has a work-around for the following:

I have two related slicers, Type 1 and Type 2. The Type 1 slicer selection changes the selection options of the Type 2 slicer as expected (first two screenshots). However, if I make a selection in the Type 1 slicer and a selection in the Type 2 slicer, and then change the selection in the Type 1 slicer, the first selection from the Type 2 slicer gets carried over (third screenshot.."B" should not be an option in Type 2 slicer when "B" is selected from Type 1 slicer, but it was carried over from the previous Type 2 slicer selection). Does anyone know of *any* way to clear the Type 2 slicer previous selection whenever the Type 1 slicer selection changes? Thank you to anyone who can help! 

1 Reply

  • That would be a question for your data model.  Please show that.

     

     

    Does anyone know of *any* way to clear the Type 2 slicer previous selection

     

    There is no programmatic way to do that in the UI, and it is not necessary (of course it can be done in DAX).  You can fudge it with bookmarks if you must.