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 in the entire report and there is no way to disable them on individual slicer.

 

It looks something like above. Can I disable it on any of the slicer where it is not needed? Can I customize these buttons to match the theme colors? 

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

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    suhailj93 it is all or nothing, you cannot customize it. You can post an idea on ideas forum.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • 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.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    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