Last Friday, I created a prototype Power BI “Slicer pane” and posted it to social media. It generated a more positive response than I would have thought. After fulfilling a client request that afternoon to double the number of slicers, the report’s primary visuals were reduced to the bottom 2/3 of the page. In my opinion, slicers were taking up too much of the report canvas.
Why not move some of those slicers to filters? Many Power BI users are not comfortable with the built-in Filter pane, or it may be disabled when embedding, etc. I wanted a solution that balanced ease of user selection with the more important results on the report–without having to rely on filters. The “Slicer pane” was the solution.
Clicking the button in the top left of the report expands or collapses the slicers.
Patrick LeBlanc presented a similar solution in a Guy in a Cube video where he toggled between content using a Search and a Filter button. Check out his walkthrough here: https://www.youtube.com/watch?v=0m-PCX1uCG4
While I will not have an opportunity to write out a detailed step-by-step post for awhile, anyone who wants to download the PBIX file and look at the setup is free to do so.
File (zip): ExpandCollapseSlicers
Get your main report page setup as desired, create a rectangle shape to act as the background for the Slicer pane, and then add slicers for the Slicer pane. Use the Send Forward/Send Backward functionality so that the main report visuals appear behind the slicers and rectangle shape, while slicers appear in front of the shape. Buttons drive navigation between two bookmarks: one with visible slicers for when the pane is expanded, and the other for hidden slicers and rectangle when it collapses. In order to get the slicer selections to “stick”, you need to uncheck the Data option on the bookmarks. Otherwise the slicer values will clear when you click the button to collapse the pane.
I’m also curious to see if and how people use this. Feel free to share ideas and improvements in the comments.
Here is a live version:
As an Amazon Associate I earn from qualifying purchases.