Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
11 months ago
Solved

How to format slicer to became a popup?

Hello,

like in a topic? 

How to make this? 


Best,
Jacek

 

  • Anonymous's avatar
    Anonymous
    11 months ago

    Hi jaryszek ,


    Totally get what you're aiming for having a slicer pop up only when needed is a slick way to keep your report clean and user-friendly. I’ve done something similar and it works like a charm. Here's how you can set it up.
    Make a slicer appear like a popup when a button is clicked.

    1. Create your slicer
      Add the slicer you want to use and format it however you like dropdown, list, etc..
    2. Hide it initially
      Go to View > Selection Pane, find your slicer, and click the eye icon to hide it.
    3. Add a button to trigger it
      Insert a button can be text or an icon like a filter. This will act as your “Show Slicer” trigger.
    4. Create bookmarks
      • Bookmark 1: Slicer visible
      • Bookmark 2: Slicer hidden
        Make sure to check “Selected visuals” when creating bookmarks so it only affects the slicer.
    5. Assign bookmarks to buttons
      • Set the “Show Slicer” button to trigger Bookmark 1
      • Optional: Add a close “X” button on the slicer and assign it to Bookmark 2
    6. Test it out
      Click the button your slicer pops up. Click the close button it disappears.


    You can group the slicer and close button together in the selection pane to keep things tidy.

    Let me know if you want help styling it to match your report theme. Happy to share ideas.


    Regards,
    Akhil.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jaryszek ,


    Totally get what you're aiming for having a slicer pop up only when needed is a slick way to keep your report clean and user-friendly. I’ve done something similar and it works like a charm. Here's how you can set it up.
    Make a slicer appear like a popup when a button is clicked.

    1. Create your slicer
      Add the slicer you want to use and format it however you like dropdown, list, etc..
    2. Hide it initially
      Go to View > Selection Pane, find your slicer, and click the eye icon to hide it.
    3. Add a button to trigger it
      Insert a button can be text or an icon like a filter. This will act as your “Show Slicer” trigger.
    4. Create bookmarks
      • Bookmark 1: Slicer visible
      • Bookmark 2: Slicer hidden
        Make sure to check “Selected visuals” when creating bookmarks so it only affects the slicer.
    5. Assign bookmarks to buttons
      • Set the “Show Slicer” button to trigger Bookmark 1
      • Optional: Add a close “X” button on the slicer and assign it to Bookmark 2
    6. Test it out
      Click the button your slicer pops up. Click the close button it disappears.


    You can group the slicer and close button together in the selection pane to keep things tidy.

    Let me know if you want help styling it to match your report theme. Happy to share ideas.


    Regards,
    Akhil.