Changing what slicers control in Power BI

Nov 3, 2022 | Power BI Hints and Tips

Slicers are a fabulous tool in Power BI producing a great user experience for filtering the visualisations in a reportBy default the slicers control all the visualisations on the page but you may need the flexibility to allow the slicer to only slice some visualisations and not others or you may need the slicer to control more than one pageBoth these options will be explored in this blog.

Controlling specific visualisations on a page using slicers 

You may decide to do this so summary visualisations remain unfiltered while all the other visualisations on the page change. 

  1. Click on the slicer visualisation already added to the page 
  2. Select the Format Tab and Edit Interactions icon 
Edit interactions in Power BI

3. The header icons will change for each visualisation.  The 2 options are Filter and None. 

Edit interactions header in Power BI Desktop

4. By default each visualisation is set to Filter 

5. The visualisations that you do not want the slicer to change should be set to none 

6. If you change your mind then Filter must be reselected 

7. Once the required changes are made the Edit Interactions icon should be selected again so the header icons revert back to their normal settings 

Be careful to ensure the slicer that controls these visualisations remains selected throughout this process. 

Controlling multiple pages of visualisation using slicers 

There are 2 methods to do this: 

Copy and Paste Slicer 

This is probably the simplest way if only 1 other page is to be controlled. 

  1. Click on the slicer visualisation already added to the page 
  2. Copy by right clicking or using the Copy icon on the Home tab 
  3. Navigate to the page the slicer is to be added to 
  4. Paste by right clicking or use the Paste icon on the Home tab 
  5. A Sync Visuals dialog box will appear.  Click on Sync 
Syc slicers dialog in Power BI Desktop

6. The location of the slicer may now need to be moved 

Changes made to the slicer on one page will now change the slicer on the other page and vice versa.  The slicer is visible on both pages. 

Use the Slicer pane 

This is a quicker method if the slicer is to be added to multiple pages.  It has the added flexibility of choosing whether the slicer is visible on other pages which can make the reports look much neater. 

  1. On the View tab select Sync Slicers.  The Sync Slicers Pane will appear 
Sync slicers pane in Power BI Desktop

2. Make sure the slicer to be synced is selected 
3. The pane will now show a list of the pages in the report and 2 tick box columns 
4. The first tick box column allows the slicer to be added or removed from the pages 
5. The second tick box column allows the slicer to visible or not 
6. Once the settings have been configured as required the pane can be closed 

NOTE: One of the ways the option of making the slicer invisible may be used is if there was a front page in the report containing a number of slicers and whatever is chosen here effects the visible content of the rest of the report.  But we may not want the slicers to be taking up valuable space on each of the other pages. 

Further Reading

If you’ve enjoyed reading how to change what Slicers control in Power BI, there’s some other blogs below that you might find useful:

Want to learn more about Microsoft Power BI? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Microsoft Power BI Desktop Courses I run.