Filters remove all but the data you want to focus on.  Highlighting is not filtering since it does not remove data but instead highlights a subset of the visible data; the unhighlighted data remains visible but dimmed.

There are a lot of different ways you can filter and highlight reports in Power BI. Putting all of that information in one article would get confusing, so we've broken it down like this:

Tip:

How does Power BI knows how data is related? It uses the relationships between the different tables and fields in the underlying data model to make items on a report page interact with each other.

Introduction to filters and highlighting in reports using the Filters pane

Filters and highlighting can be applied using the Filters pane or by making selections directly on the report itself (ad-hoc, see bottom of page). The Filters pane shows the tables and fields used in the report and the filters that have been applied, if any. The filters are divided up into Page level filters, Report level filters, and Visual level filters. You'll only see visual level filters if you've selected a visualization on the report canvas.

Tip:

If the filter has the word All next to it, that means that entire field is being included as a filter. For example, Chain(All) in the screenshot below tells us that this report page includes data about all the store chains. On the other hand, the report level filter of FiscalYear is 2013 or 2014 tells us that the report only includes data for the fiscal years of 2013 and 2014.

Filters in Reading View versus Editing View

There are two modes for interacting with reports: Reading View and Editing View.  And the filtering capabilities available to you depend on which mode you're in.

  • In Editing View, you can add report, page, and visual filters. When you save the report, the filters are saved with it. People looking at the report in Reading View can interact with the filters you added, but not save their changes.

  • In Reading View, you can interact with any page and visual filters that already exist in the report, but you won't be able to save your filter changes.

The Filters pane in Reading View

If you only have access to a report in Reading View, the Filters pane looks similar to this:

So this page of the report has 6 page level filters and 1 report level filter.

To see if any visual level filters exist, select a visual. In the image below, the bubble chart has 6 filters applied.

In Reading View, explore the data by modifying the existing filters. Learn how in the article Interact with filters in Reading view

The Filters pane in Editing View

When you have owner permissions for a report and open it in Editing View, you see that Filters is just one of several editing panes available.

As in Reading View (above) we see that this page of the report has 6 page level filters and 1 report level filter. And by selecting the bubble chart, we'd see it has 6 visual level filters applied.

But in Editing View, there is so much more that we can do with filters and highlighting. The main difference being that we can add new filters. Learn how to do this and so much more in the article Add a filter to a report

Ad-hoc filterting and highlighting

Select a field on the report canvas to filter and highlight the rest of the page. Select any empty space in the same visual to remove it. This type of filtering and highlighting is not saved with the report but is fun way to quickly explore data impacts. To fine-tune how this type of cross-filtering and cross-highlighting works, see Visual interactions

See also

Interact with filters and highlighting (in Reading View)

Add a filter to a report (in Editing View)

Take a tour of report filters

Change how report visuals cross-filter and cross-highlight each other

Read more about reports in Power BI

More questions? Try the Power BI Community