Page-level filters in Power BI - Step-by-Step Guide

Introduction

Page-level filters let you control which data appears on a whole report page. This helps you focus on specific parts of your data without changing other pages.

When you want to show sales data for only one region on a specific report page.

When you need to analyze a single product category separately from others on one page.

When your report has multiple pages and each page should show data for a different year.

When you want to compare customer segments by having each page filtered to one segment.

When you want to reduce clutter by hiding irrelevant data on a page.

Steps

Step 1: Open your report in Power BI Desktop

- Report view

You see the report pages and visuals

💡 Make sure you are on the page you want to filter

Step 2: Click the Filters pane on the right side

- Filters pane

You see filter sections for Visual, Page, and Report levels

Step 3: Drag a field from the Fields list to the Page level filters area

- Fields list and Filters pane under Page level filters

The field appears as a filter for the whole page

Step 4: Select filter values or set filter conditions

- Page level filters area in Filters pane

The report page updates to show data only matching the filter

Step 5: Click other report pages to confirm they are not affected

- Report page tabs at the bottom

Other pages show all data or their own filters

Before vs After

Before

Report page shows sales data for all regions and products

After

Report page shows sales data only for the East region after applying page-level filter

Settings Reference

Filter type

📍 Filters pane under Page level filters

Choose how to filter data on the page

Default: Basic filtering

Filter selection

📍 Filters pane under Page level filters

Specify which data to include or exclude on the page

Default: Select one or more values

Common Mistakes

Applying filters in the Visual level instead of Page level

Visual level filters affect only one visual, not the whole page

Drag the field to the Page level filters area to filter all visuals on the page

Expecting page-level filters to affect other pages

Page-level filters only apply to the current page

Use Report level filters to affect all pages or set filters separately on each page

Summary

Page-level filters control data shown on one report page in Power BI.

They help focus analysis without changing other pages.

Remember page-level filters do not affect other pages or visuals outside the page.