topic Keeping a Slicer populated when a second Slicer is filtering in Desktop

Keeping a Slicer populated when a second Slicer is filtering

jarwest — Fri, 21 Jan 2022 18:02:37 GMT

Hey all,

My issue is that I have 2 slicers on a Power BI report about people. The first slicer filters by name specifically, while the other slicer filters by group. I want to make the second slicer work in a way so that, if I select a name in the first slicer, that all of the options for group do not disappear.

I've managed to somehow do it already, so I know it is possible, but I have no idea how to recreate it.

I hope you are staying well!

Re: Keeping a Slicer populated when a second Slicer is filtering

TomMartens — Fri, 21 Jan 2022 19:18:46 GMT

Hey jarwest

assuming your table looks like this:

You can achieve what you want by changing the "Edit Interaction" setting of the 2nd slicer to none

Hopefully, this is what you are looking for and will help to tackle your challenge.

Regards,

Tom

Re: Keeping a Slicer populated when a second Slicer is filtering

jarwest — Fri, 21 Jan 2022 19:29:44 GMT

This was exactly what I was looking for, thank you so much!