Filters

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.

How to add a filter page to your report

  • 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
filter
filter
  • Open the ‘Sync slicers’ pane
  • Synchronise each slicer on each page
  • Chose to display a slicer or not on other pages
filter
  • Open the ‘Bookmarks’ pane
  • Add a bookmark and name it ‘Filters’
  • Uncheck the ‘Data’ option
filter
  • 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’
filter
  • Activate the ‘Action’
  • Select ‘Bookmark’ type
  • Select ‘Filters’ bookmark
  • Optionally type a tooltip
  • On other pages, add some visuals
filter

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
filter
  • Add a bookmark and name it ‘Clear filters
  • Keep the ‘Data’ option checked
  • Uncheck ‘Current page’
filter
  • 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

4 Comments

  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 ?

      1. Hi Didier – I was able to create a new dashboard and tested as well, and confirmed it works! I did some research and couldn’t find much about it from Microsoft, but did see when they introduced the features that embedded wasn’t supported. Somewhere along the way, it’s now supported and I’m not angry about it! Such a great, and needed feature for how we build and use Power BI reports.
        Thank you for the great article, I hope your readers find similar value in the feature!

Leave a Reply

Your email address will not be published. Required fields are marked *