1. Add a filter page to your report

There are different ways to filter data in Power BI reports. My favorite one is to create a specific filter page containing many slicers. These filters will be applied to the whole report or to a part of it. In next posts, I will show you how to display the applied filters in pages.

Try it here :

How to

  • Add a page to the report and name it ‘Filters’
  • Optionally, you may hide this tab
  • Add in the page:
    • some slicers
    • a card to display the number of rows which are filtered
    • a ‘Back’ button
  • Open the ‘Sync slicers’ pane
  • Synchronise each slicer on each page
  • Chose to display a slicer or not on other pages
  • Open the ‘Bookmarks’ pane
  • Add a bookmark and name it ‘Filters’
  • Uncheck the ‘Data’ option
  • On other pages, add a blank button
  • In the ‘VISUALIZATIONS’ pane, activate the ‘Button text’ option
  • Type ‘Filters’ in the ‘Button text’ field
  • Increase the ‘Text size’
  • Activate the ‘Action’
  • Select ‘Bookmark’ type
  • Select ‘Filters’ bookmark
  • Optionally type a tooltip
  • On other pages, add some visuals
Other page

Then, you can control click on the ‘Filters’ button, select some filters, control click on the ‘Back’ button and look at the effect on other pages.

How to add a ‘Reset filters’ button (optional)

  • Go to the ‘Filters’ tab
  • Remove all filters
  • Add a bookmark and name it ‘Clear filters
  • Keep the ‘Data’ option checked
  • Uncheck ‘Current page’
  • Add a ‘Reset’ button
  • Activate the ‘Action’
  • Select ‘Bookmark’ type
  • Select ‘Clear filters’ bookmark
  • Optionally type a tooltip
  • Copy and paste this button to other pages

  • Try the ‘Reset’ button in all pages

Here is the pbix file of the demo : download demo ‘Report filters.pbix’

This post is a part of a series : see the seriessee next post

3 thoughts on “1. Add a filter page to your report”

  1. Syncing slicers across pages is fantastic, but the feature is not currently supported when you embed the report on a web page, FYI.

    1. Mike, I added a sample report in this post and it seems to work. Additionally, I embedded the report in SharePoint and it works there also. Can you explain what doesn’t work exactly ?

Leave a Comment

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.