Forum Discussion

suhailj93's avatar
suhailj93
Frequent Visitor
6 years ago
Solved

Customize apply button in slicer which is provided for query reduction

Hi everyone,   I have a report where i need to use query reduction technique by enabling apply buttons on slicers but I could not find any option to customize them. It is enabled for every slicer i...
Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi suhailj93,

     

    Sorry there is currently no option to customize it or turn off the apply button on a single slicer. When you turn off this option in the option, it will cancel the apply button on all slicers.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi suhailj93 ,

 

You cannot make the selection on slicers with an apply button, one option could be to configure bookmarks that shows the slicers that you need so when you need you will have them usable or not.

 

What I did in the attach file was to:

  • Create a button to place on top of each slicer
  • Create a bookmark for each of the option on the slicer on/off
  • Selected on the button that is on top of the slicer and made one with button showing and not showing
  • Create a button to clear all

Now you have buttons to turn on and off, if you want the apply then you can place the buttons on/off on top of each other and also hide one and show the other that way people will only see one button.

 

This is a work around but maybe can be adjust for your needs.