Forum Discussion

Nabil20_24's avatar
Nabil20_24
Icon for Helper I rankHelper I
2 years ago
Solved

Hide all slicers

Hi, I have a Power BI dashboard that contains 10 pages; each page has one or more slicers. I want to hide all slicers when converting to PDF. Here’s what I’ve done so far that hasn’t worked: ...
  • suparnababu8's avatar
    2 years ago

    Hi Nabil20_24 

     

    You have to hide all slicers while exporting to PDF. In this case you have to follow the below steps.

    PowerBI Desktop>> View>>Click on sync slicers

    After opening above pane, you just hide the filters across all pages and export it to PDF.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from bhanu_gautam, PijushRoy and suparnababu8.

     

    Hi Nabil20_24 ,

     

    If you just to hide all the slicer and export to PDF , then suparnababu8 's reply is to realize your requirements. Then if you still want to keep the button selection effect, I provide you with a method similar to your needs, except that it may be more cumbersome and I use the new slicer. Here are my steps:

     

    1.Here are my test tables:financials and Table.

    2.Created a slicer approximation of the button.

    2.Create a measure  and the color will change to white when we select hide.

     

     

    Measure = 
    SWITCH(
        TRUE(),
        SELECTEDVALUE('Table'[Hide all slicers])="Hide","white","black")
    

     

     

     

    3.Set callout values and button colors in the visualization pane.

    (1)Callout values color setting:

    (2)Button color setting:

    Select "Default".

    Select "Selected".

    4.The final results are as follows.

    Click on "Hide":

    Click on "Interactive":

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!