Take a tour of the report Filters pane

This article takes a look at the report Filters pane in the Power BI service. Use the filters to discover new insights in your data.

There are many different ways to filter data in Power BI. For more info about filters, see Filters and highlighting in Power BI reports.

Screenshot of a report in the browser with an arrow pointing to the Filters option.

Working with the report Filters pane

When a colleague shares a report with you, be sure to look for the Filters pane. Sometimes it's collapsed along the right edge of the report. Select it to expand it.

Screenshot of the report with the Filters pane expanded.

The Filters pane contains filters that the report designer added to the report. Consumers like you can interact with the existing filters and save your changes, but you can't add new filters to the report. For example, in the screenshot above the designer added two page level filters: Segment and Year. You can interact and change these filters, but you can't add a third page level filter.

In the Power BI service, reports keep any changes you make in the Filters pane. The service carries those changes through to the mobile version of the report.

To reset the Filters pane to the designer's defaults, select Screenshot of the Reset to default option. from the top menu bar.

View all the filters for a report page

The Filters pane displays all filters added by the designer to the report. The Filters pane is also the area where you can view information about the filters and interact with them. You can save changes you make or use the Reset to default to revert to the original filter settings.

If there are changes you'd like to save, you can also create a personal bookmark. For more information, see What are bookmarks?.

The Filters pane displays and manages several types of report filters. They can be applied to a visual, to a report page, and to the entire report.

In this example, we've selected a visual that has two filters. The report page also has filters, listed under the Filters on this page heading. Also, the entire report has a filter for Date.

Screenshot of a report with a visualization and its related filters called out.

Some of the filters have (All) next to them. (All) means all values are being included in the filter. In the screenshot above, Segment(All) tells us this report page includes data about all the product segments. If you select the Region is West page level filter, the report page only includes data for the West region.

Anyone viewing this report can interact with these filters.

View only those filters applied to a visual

To get a closer look at the filters applied to a specific visual, hover over the visual to reveal the filter icon Screenshot of the Filter icon.. Select that filter icon to see a pop-up with all the filters, slicers, and so on, affecting that visual. The filters on the pop-up are the same filters displayed on the Filters pane.

Screenshot of a list of filters with arrows pointing to where those filters are on the Filters pane.

Here are the types of filters this view can display:

  • Basic filters

  • Slicers

  • Cross-highlighting

  • Cross-filtering

  • Advanced filters

  • Top N filters

  • Relative Date filters

  • Sync-slicers

  • Include/Exclude filters

  • Filters passed through a URL

In the following example:

  1. We can see that the column chart has been cross-filtered.

  2. Included tells us that the cross-filter is for Segment, and three are included.

  3. A slicer has been applied for Quarter.

  4. Region is a filter applied to this report page, and

  5. isVanArsdel and Year are filters applied to this visual.

Screenshot of a report and its filters with the list of filters numbered to coincide with the numbered list above.

Search in a filter

Sometimes a filter can have a long list of values. Use the search box to find and select the value you want.

Screenshot of how to search in a filter.

Display filter details

To understand a filter, take a look at the available values and counts. View the details of the filter by hovering and selecting the arrow next to the filter name.

Screenshot of a filter that shows the west region selected.

Change filter selections

One way to search for data insights is to interact with the filters. You can change filter selections using the drop-down arrow next to the field name. Depending on the filter and type of data that Power BI is filtering, your options will range from simple selections from a list to identifying ranges of dates or numbers. In the advanced filter below, we've changed the Total Units YTD filter on the treemap to be between 2,000 and 3,000. Notice that this change removes Prirum from the treemap.

Screenshot of a report and its filters that shows Fashions Direct selected.

Tip

To select more than one filter value at a time, hold down the CTRL key. Most filters support multi-select.

Reset filter to default

If you want to back out of all changes you've made to the filters, select Reset to default from the top menu bar. This selection reverts the filters to their original state, as set by the report designer.

Screenshot of the Reset to default option.

Clear a filter

If there's just one filter that you'd like to set to (All), clear it by selecting the eraser icon Screenshot of the Eraser icon. next to the filter name.

Next steps

Learn how and why visuals cross-filter and cross-highlight each other on a report page