In this power bi tutorial, we will see the power bi slicer panel. And also we will discuss the below points:
- What is power bi slicer panel?
- How to add slicer panel in Power BI
- Add Power bi slicer panel on multiple pages
- Power bi hidden slicer panel
What is Power bi slicer panel?
By using the Power bi slicer panel, you can show or hide those slicers to free up space inside the report and to make it a little cleaner.
Power bi add slicer panel
Here we will see how to add a slicer panel in power bi using the Power BI desktop.
Scenario: To create a slicer panel in power bi:
For this first, we will create a Power BI report, you can download the sample data from here. Once the report is ready for the below points.
- First we will create a panel by using the text box where we will add slicer.
- Then we will use the selection panel to reorder the visuals, so that the slicer and text box is visible.
- By using selection, we will hide and show the items in the slicer panel.
- We will add left arrow buttion on the panel, which will use to hide the panel.
- And we use the bookmark to save the functionality i.e slicer panel hidden which we name as slicer hidden.
- We will add right arrow buttoon on the panel, which we will use to show the slicer panel
- Then we will configure the bookmark as slicer visible in the Selection pane and save it as bookmark.
- Last step is to add the bookmark to the left arrow and right arrow i.e slicer hidden bookmark and slicer visible bookmark.
Step 1: Create a panel for your slicers
- In Power bi desktop. Select a text box from the ribbon.
- Adjust the text box in the canvas.
- Select a slicer from the visualization.
- In the field, drag and drop the fiscal year column from the Field pane.
- Then Adjust this slicer and reset this slicer in the pane. And also you can add more slicer to the pane.
- Now you may want to rearrange the visual, so that the text box and slicer is visible.
- To reorder the visuals, click on the view -> Selection.
- Now selection pane will open in between the filter pane and visualization pane.
- Here you can move the item up and down the list using drag and drop to control which Item sits on top of which the objects.
In the power bi hide slicer panel, we will see how to hide the slicer panel in the
Step 2: Navigate button to hide slicer panel
- Click on the Insert tab from the ribbon.
- Click on the button -> left arrow.
- Once you click on the left icon, position the left arrow icon on the top of the slicer pane.
Step 3: Navigate the button to Show a slicer button
- In the selection pane, hide the object that makes new slicer pane.
- To do this click on the eyeball, next to each item that needed to be hidden.
- Click on the insert tab from the ribbon.
- Then click on the button -> Right arrow.
- Turn on the border for the right arrow.
Step 4: Add bookmarks
Bookmarks that enable you to toggle between the views. To enable it follow the below steps:
- Click on the view tab from the ribbon.
- Select the bookmark icon in the Shows panes section.
- First we configure the bookmark with the slicers pane hidden in the selection pane.
- Then click on Add icon in the bookmark section.
- Now rename the bookmark. To rename the bookmark click on the more icon -> select Rename. Rename as Slicer Hidden.
- We don’t want the bookmark to return the slicer filter back to where they were when bookmark is created.
- Instead of that, we want the bookmark to ignore the slicer filter setting all together in power bi.
- To fix this problem, we need to uncheck the Data option from the more option.
- Then click on update.
- We will set up the view, that has slicers visible in the selection pane.
- To do this toggle the visibility of items to show ones needed in the report.
- Click on Add in bookmark pane.
- Rename the bookmark as slicer visibility.
- Click on the More icon and uncheck the data and Then click on Update.
You can test the bookmark by clicking on the bookmark pane on the power bi desktop. When you click on the Slicer visible, you can see the slicer pane.
And when you click on the Slicer hidden in the bookmark pane it will hide the slicer pane.
Step 5: Assign bookmark to button
- Here you need to assign the two bookmark to the right arrow and left arrow buttons added.
- Select the right arrow button.
- Format button pane will open in the right side
- Expand the action section, turn on the action.
- Under type select Bookmark. Then under bookmark select slicer hidden.
- Then under tooltip write Slicer hidden. It will show when you hover over the right arrow.
- Similarly add bookmark for left arrow, click on the left arrow in the slicer pane.
- Format button pane will open in the right side
- Expand the action section, turn on the action.
- Under type select Bookmark. Then under bookmark select slicer visible.
- Then under tooltip write Slicer visible. It will show when you hover over the left arrow.
Now your slicer panel is ready and you can test it using the arrow button. To see whether the button is working Ctrl+ click on the button.
Read Power Bi slicer multiple selections
Power bi slicer panel multiple pages
Here we will see power bi slicer panel multiple pages in power bi desktop.
- From the above slicer panel, click on the slicer in power bi desktop.
- Go to view tab and select Sync slicers.
- Then in the sync slicer panel, check the box under the eye icon, to show the slicer on multiple pages.
- Here i have selected in all pages to show the slicer.
- And under sync icon, you can select in which page you want to sync the slicer.
Now you can see the slicer on multiple pages on the power bi desktop.
This is how to add a Power bi slicer panel on multiple pages.
Power bi hidden slicer panel
Here we will see the power bi hidden slicer panel in the power bi desktop.
We will see how to show hidden slicer in power bi desktop. To show the hidden slicer
- Click on the view tab and then click on the Selection, it will open the selection pane in between the filter and visulaization pane.
- In the selection pane, you can toggle on the eye icon to see the slicer in the canvas or slicer panel.
In the below screenshot you can see the power bi hidden slicer
- If you toggle off the slicer in the selection panel in power bi desktop.
- One slicer is hidden and another slicer is visible in Selection pane, So in slicer pane only one slicer will shown.
- In the below screenshot you can see the power bi hide slicer
You may like the following Power BI tutorials:
- Power bi measure switch statement
- Microsoft Power BI Stacked Column Chart
- Power BI waterfall chart
- Power bi row level security tutorial
- Power bi calculated column vs measure
- How to change data source in Power BI
- Power bi show value as percentage
- Power BI Date Function
In this power bi tutorial, we discussed the power bi slicer panel. And also we discuss the below points:
- What is power bi slicer panel?
- Power bi add slicer panel
- Power bi slicer panel multiple pages
- Power bi hidden slicer panel
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com