How can I stop Power BI slicers from showing selected values that are visually filtered out?

[Hannahllmm]

For context:
This video shows the bare bones of what I want to set up: Allow user to select columns for table visual in Power BI

I want a table where users have the option to select the fields they want displaying in that table. 
But rather than 4 fields to choose from like in the video we have about 50 in a field parameter. But most users are only interested in 5 of those 50. So we have one slicer that has been filtered to only show those 5 fields, users can select from those 5 and most will be happy using just that. But for the users who want to do some more in depth analysis they want to see all 50 so I have a button which is set up to link to a bookmark to reveal the full 50 fields they can add to the table. Rather than being one long list this will be 5 slicers each with 10 options. So there are in total 6 slicers on the page. Below is my actual question where I've set up a mock up with just 3 slicers and 7 categories to show the issue I'm having.

Actual Question:
I have three slicers on the same Power BI page, each filtered to show different subsets of a category field (categories 1–3, 3–4, and 4–7). I've given them all the same group name so if someone ticks Field 3 in the main slicer then Field 3 will be selected in the secon slicer. I've disabled the "Sync filter changes to other slicers" so the different subsets of categories can be set up. The issue is that when I select a value in one slicer, it shows up as selected in another—even if that category is filtered out and shouldn't be visible. Is there a way to stop slicers from displaying selected values that are outside their visual-level filters?

Eg these are my slicers with visual filters applied:

But if I then select Field 1 from the secon slicer it looks like this:

I don't want the "Field 1" to show in the other two slicers.

Any help would be great thanks!

[v-kpoloju-msft]

Hi @Hannahllmm,

Thank you for reaching out to the Microsoft fabric community forum.  I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it. Used line chart.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[Hannahllmm]

Hi, thank you for your responce. It doesn't quite work as I'd want it to because this would be used to pick the fields wanted in a table so using a field parameter and we wouldn't want duplicated columns. The solution was to switch to using the new list slicers. Thank you though

[MFelix]

Hi @Hannahllmm ,

Since you are using the same column to do all your different slicers even each one being filter at a specific category they will  sinc up.

I would advise you to instead of having a 50 field parameter table in your model to split it into th e5 different groups you want and then add all of those values to the visuals, they will work in the same way, the only difference is that the selection order will be based on each of the tables.

What I mean is that when you have a field parameter if you select the measures 11, 4, 45, 42 they will be presented in that exact order 11, 4, 45, 42 . using different groups assuming that you would do 5 groups of 10 the same selection would give you 4, 11, 45, 42 because they are in different groups except for the last two that are in the same one.

[Hannahllmm]

Hi, thank you for your responce. I did try this but the problem was that if a user selected something that was part of the main attributes (first slicer in my example) then that option wouldnt be ticked when looking at the full list. And unfortunatly the ordering of the fields was something users have said is important to them

[MFelix · Accepted solution]

Hi @Hannahllmm ,

If that is the case I would suggest you to change the look and feel of your slicers.

Some options that you may consider:

• Hierarchy Slicer
• New Button slicer (allows to show values in a grid manor)
• New List slicer (allows to do a pagination on the slicer)

If you want I can try and make some examples and share with you.

[Hannahllmm]

Wow! Switching all the slicers to the new list slicer fixed this straight away and gives me exactly what I want!! Thank you so much. Do you know why this solves the issue? are filters applied differently in list slicers compared to normal slicers? I don't quite understand why the behaviour is different

[MFelix]

Hi @Hannahllmm ,

The new slicers (Button, list and text) are being improved and have different options not really sure what are the main differences on the way they work, but they are improving how it works.

Glad it works.

Don't forget to mark the correct answer or share how you have setup everything so it can help other users.