Jon Gallant

Power BI: How to Clear All Filters on a Power BI Report

2 min read

It quite common to lose track of what filters you currently have applied to a Power BI report. Also, there’s no out of the box way to clear them all. So, here’s how to do it.

We’re going to add an image and a bookmark when no filters set. When a user CTRL+clicks on the image, the bookmark will be activated and clear all filters.

Create Bookmark

  1. Clear all filters on your report. Get it into a state that you want it to be in when the user clicks the Clear Filters button.
  2. Go to View -> Bookmarks

022

  1. Click Add

023

  1. Name it Clear Filters

027

Insert Image

  1. Go to Insert -> Image and select a filter image. I recommend you download this one: https://github.com/jongio/icons/blob/master/clearfilter/clearfiltericon.png

019

Position and resize it to suit your needs.

021

  1. Click the image
  2. In Format Image pane, turn on Action.
  3. Select Bookmark
  4. Select the Clear Filters bookmark. If you don’t see it, turn the action toggle off and then back on.
  5. Give it a tooltip. I entered CTRL+Click to Clear Filters. Because users might not know they need to click CTRL.

028

026

CTRL+Click the image to test it out. Publish. Profit.

Jon

Share:
Share on X