Tip:

We recommend first reading About filters and highlighting in Power BI reports.

What is the difference between report filters in Editing View versus Reading 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 report, page and visual filters that already exist in the report, but you won't be able to save your filter changes.

Note:

This article describes how to create filters in report Editing View.  For more information on filters in Reading VIew, see interacting with filters in report Reading View.

Visual filters, page filters, and report filters

A page filter applies to all the visuals on the report page. A visual filter applies to a single visual on a report page. And a report filter applies to all pages in the report.

Add a filter to a specific visualization (aka visual filter)

By filtering the fields already in the chart

  1. Open your report in Editing View.

  2. Open the Visualizations and Filters pane and the Fields pane (if they're not already open).

  3. Select a visual to make it active. All the fields being used by the visual are identified in the Fields pane and also listed in the Filters pane, under the Visual Level Filters heading.

  4. At this point you can either add a filter to a field already being used by the visualization, or you can use a different field as a filter.

  5. Add a filter to a field already being used by the visualization.

    • Add a filter to a field already being used by the visual. Scroll down to the Visual level filters area and select the arrow to expand the field you'd like to filter.
    • Set either Basic or Advanced filtering controls (see How to use report filters).

    • The visual changes to reflect the new filter. If you save your report with the filter, report readers can interact with the filter in Reading View, selecting or clearing values.

  6. Add a new field as a filter.

    • From the Fields pane, select the field you want to add as a new visual level filter, and drag it into the Visual level filters area.
    • Follow steps 2-3 above.

Add a filter to an entire page (aka page view filter)

  1. Open your report in Editing View.

  2. Open the Visualizations and Filters pane and the Fields pane (if they're not already open).

  3. From the Fields pane, select the field you want to add as a new visual level filter, and drag it into the Page level filters area.

  4. Select the values you want to filter and set either Basic or Advanced filtering controls (see How to use report filters).

    The visualization changes to reflect the new filter. 

If you save your report with the filter, report readers can interact with the filter in Reading View, selecting or clearing values.

Add a filter to an entire report (aka Report filter)

  1. Open your report in Editing View.

  2. Open the Visualizations and Filters pane and the Fields pane (if they're not already open).

  3. From the Fields pane, select the field you want to add as a new visual level filter, and drag it into the Report level filters area.

  4. Select the values you want to filter (see How to use report filters).

The visuals on the active page, and on all pages in the report, changes to reflect the new filter. If you save your report with the filter, report readers can interact with the filter in Reading View, selecting or clearing values.

Troubleshooting

Why your visual level filter and page level filter may return different results

When you add a visual level filter, Power BI filters on the aggregated results. The default aggregation is Sum, but you can change the aggregation type.

When you add a page level filter, Power BI filters without aggregating. It does this because a page can have many visuals which can each utilize different aggregation types. So the filter is applied on each data row.

See also

How to use report filters

Filters and highlighting in reports

Interact with filters and highlighting in report Reading View

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

Read more about reports in Power BI

Power BI - Basic Concepts

More questions? Try the Power BI Community