Power bi slicer panel – How to use

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.
power bi slicer panel
power bi slicer panel
  • Select a slicer from the visualization.
  • In the field, drag and drop the fiscal year column from the Field pane.
power bi desktop slicer panel
power bi desktop slicer panel
  • Then Adjust this slicer and reset this slicer in the pane. And also you can add more slicer to the pane.
Power bi add slicer panel
Power bi add slicer panel
  • 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.
Power bi add slicer panel
Power bi add slicer panel
  • 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.
Power bi add slicer panel
Power bi add slicer panel

In the power bi hide slicer panel, we will see how to hide the slicer panel in the

See also  failed to create connection for connection id in Power Automate

Step 2: Navigate button to hide slicer panel

  • Click on the Insert tab from the ribbon.
  • Click on the button -> left arrow.
Power bi add slicer panel
Power bi add slicer panel
  • Once you click on the left icon, position the left arrow icon on the top of the slicer pane.
power bi slicer panel
power bi slicer panel

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.
power bi desktop slicer panel
power bi desktop slicer panel
  • Click on the insert tab from the ribbon.
  • Then click on the button -> Right arrow.
  • Turn on the border for the right arrow.
power bi desktop slicer panel
power bi desktop slicer panel

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.
power bi desktop slicer panel
power bi desktop slicer panel
  • First we configure the bookmark with the slicers pane hidden in the selection pane.
  • Then click on Add icon in the bookmark section.
power bi hide slicer panel
power bi hide slicer panel
  • Now rename the bookmark. To rename the bookmark click on the more icon -> select Rename. Rename as Slicer Hidden.
power bi hide slicer panel
power bi hide slicer panel
  • 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.
Microsoft power bi add slicer panel
Microsoft power bi add slicer panel
  • 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.
Microsoft power bi add slicer panel
Microsoft power bi add slicer panel
  • 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.
Microsoft power bi add slicer panel
Microsoft power bi add slicer panel

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.

See also  Power Apps Rich text editor control - How to use

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.
How power bi add slicer panel
How power bi add slicer panel
  • 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.
Microsoft power bi add slicer panel
Microsoft power bi add slicer panel

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.

Microsoft power bi add slicer panel
Microsoft power bi add slicer panel

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.
Power bi slicer panel multiple pages
Power bi slicer panel multiple pages
  • Go to view tab and select Sync slicers.
power bi slicer panel for all pages
power bi slicer panel for all pages
  • 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.
power bi slicer panel for all pages
power bi slicer panel for all pages

Now you can see the slicer on multiple pages on the power bi desktop.

power bi slicer panel multiple pages
power bi slicer panel multiple pages

This is how to add a Power bi slicer panel on multiple pages.

See also  Power bi show items with no data

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.
power bi hidden slicer panel
power bi hidden slicer panel
  • In the selection pane, you can toggle on the eye icon to see the slicer in the canvas or slicer panel.
power bi hidden slicer panel
power bi hidden slicer panel

In the below screenshot you can see the power bi hidden slicer

power bi hidden slicer panel
power bi hidden slicer panel
  • If you toggle off the slicer in the selection panel in power bi desktop.
power bi hidden slicer panel
power bi hidden slicer panel
  • 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
power bi hidden slicer panel
power bi hidden slicer panel

You may like the following Power BI tutorials:

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
>