Is there any way to exclude one slicers from the Apply all slicers button?

[hari27pn]

I have 48 slicers in my dashboard + one Year and Application slicer. Now if I go through each slicer from the 48 group then it takes a lot of loading time. So, I definitely need the apply all slicers button for this which will help query reduction. 
But I want my Year and application slicer to work normally without clicking the apply all button.
Is there any way to solve this?

[AmiraBedh · Accepted solution]

If you're using a tool that allows multiple pages or tabs within a dashboard, you might separate the slicers that need to be applied together on one page, and the ones you want to work separately on another.

Instead of applying the slicers all at once, you could attempt to logically separate them, perhaps by placing them in different visual containers. Then, guide users to apply one set of slicers before moving on to the next. While not a direct solution, this may help achieve the desired user experience.

[AmiraBedh]

There's no native functionality to exclude specific slicers from the "Apply all slicers" button. A workaround might include separating slicers logically, using different pages, or custom development using available APIs or scripting languages. Other strategies may include engaging with community forums or the platform's support for specialized guidance, or monitoring updates from the software provider for new features that might address this limitation. Unfortunately, without specific functionality designed to exclude a slicer, achieving the desired effect may require inventive solutions or compromises.

[danextian]

Hi @hari27pn ,

As per Power BI Blog

Some things to keep in mind with these buttons:

• Apply all slicers and Clear all slicers buttons impact all the slicers on the report page. You cannot pick and choose which slicers you want each button to control. They also do not control the filters pane.
• You can have as many of these buttons on your report page as you like! If you have most of your slicers in one section, but maybe one or two slicers in another section, you can simply have a button in both sections. Either button, when pressed, will apply to all the slicers on the report page.
• Hiding the last Apply all slicers button will simply release its control over the slicers and they will revert to instantly applying selections as you click.

https://powerbi.microsoft.com/en-my/blog/deep-dive-into-the-new-apply-all-slicers-and-clear-all-slic...