Skip to main content

Data & Intelligence

Hide and Show Slicer Pane in Microsoft Power BI Desktop Application.

Istock 871840512

Power BI Desktop is a free Analytics and Business Intelligence application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data.

Power BI transforms your  Data into appealing and insightful visuals.  Firstly You can absorb in a glance and After that you can take better Decision.

Lets see how to Hide and show Slicer Pane in Microsoft  power BI desktop step by step .

  1. Get the data in power BI desktop. Select a rectangular shape and place your slicers on top of it with a left arrow button ,which indicates as to close. Make sure you bring the slicers, rectangular shape (which acts as placeholder). The left arrow on top in the respective order by ‘bring forward/send forward’ in the Format Tab.  Pic11
  2. Select all Slicers, Button, rectangle by pressing CTRL Key and group them.  All elements will act as one and rename it as slicer panel(ref below screenshot)Pic22
  3. Now it’s time to create the Two Bookmarks. go to View- add Bookmark, named it as show slicer panel and uncheck the data.Pic33
  4. Hide the slicer panel in selection pane . Add the second Bookmark, named it as Hide Slicer Panel. Remember to uncheck the data as well.Pic44
  5. Select the left arrow Button. Go to format -turn on action -select type as bookmark-select bookmark type as Hide Slicer Panel – provide tool tip as Hide the slicer Panel.Pic55
  6. Now add right arrow  button. Select the button go to format, turn on action -select type as bookmark-select bookmark type as Show Slicer Panel – provide tool tip as Show slicer Panel.Pic66

We have successfully created the Hide and Show the slicer panel. Hover over to left arrow button and it will show tooltip hide slicer pane. Press CTRL key and select the left Arrow button and it will hide the slicer. Press CTRL and select Right arrow Button, it will show the Slicer.Pic7Pic8

we have successfully created the Hide and Show Slicer Pane in Power BI Desktop.

Thoughts on “Hide and Show Slicer Pane in Microsoft Power BI Desktop Application.”

  1. Is it possible to hide the slicers but keep the selected values without having to update the bookmark?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Vaibhav Punwatkar

Vaibhav Punwatkar is a Senior Technical Consultant at Perficient. He is a Power BI developer and Power BI service Consultant. Vaibhav is excited to share his knowledge about Power BI and is open to suggestions from readers.

More from this Author

Follow Us