Using Visual-Level, Page-Level, and Report-Level Filters in Microsoft Power BI

Course: Microsoft Power BI Training

Topic: Using Visual-Level, Page-Level, and Report-Level Filters

Course Link: Microsoft Power BI Training – JustAcademy

Demo Link: Register for a Course Demo

JustAcademy Website: Visit JustAcademy

1. Introduction to Filters in Power BI

Microsoft Power BI is a business intelligence and data visualization platform that enables users to analyze data through interactive reports and dashboards. Filters are an important feature in Power BI because they allow users to focus on specific information instead of viewing an entire dataset at once.

A filter restricts the data displayed in a visual, on a report page, or throughout an entire report. For example, a sales manager might want to view sales for a particular region, a financial year, or a specific product category.

Power BI provides three main filter levels:

• Visual-level filters: Apply to one selected visual.
• Page-level filters: Apply to all relevant visuals on one report page.
• Report-level filters: Apply across all report pages.

Choosing the correct filter level helps make reports easier to manage, more relevant to users, and more effective for business analysis.

1.1 Why Filters Are Important

• Focus on relevant records and categories.
• Reduce unnecessary information in reports.
• Support detailed analysis of specific business questions.
• Allow users to compare products, regions, customers, and periods.
• Improve report usability and decision-making.
• Help report designers establish consistent filtering rules.
• Make it easier to investigate trends and exceptions.

1.2 Example of Filtering

Suppose a company has sales data for four regions: North, South, East, and West. The dataset contains sales transactions from 2024, 2025, and 2026.

Different filtering requirements might include:

• Show only the sales chart for the North region.
• Display all visuals on a page for the year 2026.
• Restrict every report page to a particular country.

These requirements can be handled using visual-level, page-level, and report-level filters, depending on the desired scope.

2. Understanding the Filters Pane

The Filters pane is the main interface used to create and manage filters in Power BI Desktop and the Power BI service when editing a report.

2.1 How to Open the Filters Pane

1. Open Power BI Desktop.
2. Open an existing report or create a new report.
3. Go to Report view.
4. Locate the Filters pane beside the report canvas.
5. If the pane is hidden, open it using the available pane controls.
6. Select a visual or choose a report page to inspect its filter sections.

2.2 Main Filter Sections

The exact labels and pane layout may vary slightly between Power BI versions and editing experiences.

3. Understanding Visual-Level Filters

A visual-level filter applies to a single visual on a report page. It does not directly apply the same filter to the other visuals on that page.

Visual-level filters are useful when one chart needs a more specific view than the rest of the report.

3.1 Example of a Visual-Level Filter

Imagine a report page contains three visuals:

• Visual 1: Total Sales by Region
• Visual 2: Profit by Product Category
• Visual 3: Sales by Month

If you apply a visual-level filter that selects the North region only for Visual 1, that chart displays North-region sales. The other two visuals do not automatically receive that same visual-level filter.

3.2 When to Use Visual-Level Filters

• When one chart should display only a specific product.
• When a table needs to show selected customers only.
• When a chart should display the top-performing categories.
• When one visual needs a specific date or numeric range.
• When different visuals on the same page require different data subsets.

3.3 Steps to Apply a Visual-Level Filter

1. Select the chart, table, card, or other visual you want to filter.
2. Open the Filters pane.
3. Find the section labeled Filters on this visual.
4. From the Data or Fields pane, locate the field you want to filter.
5. Drag the field into the Filters on this visual section if it is not already present.
6. Expand the filter card.
7. Select the values or conditions you want to apply.
8. Review the selected visual to confirm that it displays the expected data.

3.4 Example: Filtering a Sales Chart

Suppose the sales table contains the following records:

If a visual-level filter selects Product = Laptop, the selected visual displays laptop sales only.

The resulting records for that visual are:

Other visuals remain governed by their own filters, along with any applicable page-level and report-level filters.

3.5 Visual-Level Filtering with Fields Not Displayed in a Visual

A field does not always need to appear in a chart's displayed categories or values to be used as a visual-level filter. For example, a chart showing sales by month can be filtered using a Customer Segment field even if Customer Segment is not visible in the chart.

This is useful when report designers want to restrict a visual without adding more labels or categories to the chart itself.

4. Understanding Page-Level Filters

A page-level filter applies to the relevant visuals on one report page. It is useful when an entire page should focus on a specific time period, region, business unit, or category.

Unlike a visual-level filter, a page-level filter is not restricted to one selected chart. It helps establish a shared filtering context for the page.

4.1 Example of a Page-Level Filter

Suppose a report page contains:

• A sales summary card.
• A sales-by-region chart.
• A profit-by-category chart.
• A monthly sales trend chart.

If you apply a page-level filter for Year = 2026, the relevant visuals on that page display data for 2026, subject to other filters and visual configurations.

4.2 When to Use Page-Level Filters

• When an entire page should focus on one year or quarter.
• When a page is dedicated to one region or business unit.
• When every visual on a page should analyze one customer segment.
• When a report contains separate pages for different analytical topics.
• When the same filtering condition should apply consistently across multiple visuals on one page.

4.3 Steps to Apply a Page-Level Filter

1. Open the report in editing mode.
2. Navigate to the report page you want to filter.
3. Locate the Filters pane.
4. Find the section labeled Filters on this page.
5. Drag the required field from the Data pane into that section.
6. Expand the filter card.
7. Select the desired values or define a condition.
8. Check the visuals on the page to confirm that the filter is applied correctly.
9. Move to another page and verify that the page-level filter has not unintentionally changed that page.

4.4 Example: Filtering a Page by Region

Suppose the report has a page called Regional Sales Analysis. The page contains several charts showing sales, profit, products, and monthly performance.

Applying a page-level filter Region = South makes the relevant visuals on that page focus on the South region.

A different page, such as Company Overview, can still show all regions unless its own filters or a report-level filter restrict the data.

4.5 Page-Level Filters and Page Navigation

Each report page can have its own page-level filters. For example:

Remember that page-level filters do not automatically synchronize their selections across separate pages. Use synchronized slicers or another appropriate design when users need the same interactive selection across multiple pages.

5. Understanding Report-Level Filters

A report-level filter applies across all pages in a Power BI report. It is useful when a condition should remain consistent throughout the report.

For example, a company may want a report to display data for India only. A report-level filter can restrict the report to Country = India, so that all report pages use that filter context.

5.1 When to Use Report-Level Filters

• When the entire report should focus on one country or business entity.
• When all pages must use the same financial year or reporting period.
• When a report is designed for a particular product line.
• When a shared condition should apply throughout the report.
• When a report author needs a consistent baseline for analysis.

5.2 Steps to Apply a Report-Level Filter

1. Open the report in editing mode.
2. Locate the Filters pane.
3. Find the section labeled Filters on all pages.
4. Drag the field you want to filter into that section.
5. Expand the filter card.
6. Select the required values or conditions.
7. Review multiple report pages to verify the filter's effect.
8. Save the report if you want the selected filter state to be part of the saved report configuration.

5.3 Example: Filtering an Entire Report by Country

Imagine a report with these pages:

• Executive Summary
• Sales Analysis
• Profit Analysis
• Customer Analysis
• Product Analysis

Applying a report-level filter Country = India restricts the relevant data on all those pages to India, subject to the model relationships and other filter conditions.

This can be useful when the report is intended to analyze one market consistently across several business topics.

5.4 Important Considerations

• Report-level filters affect all pages, so verify the intended scope before publishing.
• Page-level and visual-level filters can narrow the results further.
• A more specific filter at a lower level does not generally cancel a conflicting higher-level filter.
• Check every page after applying a report-level filter.
• Do not confuse report-level filters with security controls such as Row-Level Security (RLS).

6. Comparing Visual-Level, Page-Level, and Report-Level Filters

7. Understanding Filter Types

Power BI supports different filter types depending on the field, data type, visual, and filter level. The most common types include basic filtering, advanced filtering, relative date filtering, and Top N filtering where supported.

7.1 Basic Filtering

Basic filtering allows users to select one or more values from a list.

Example: Select North and South from the Region field to show data for those two regions.

Basic filtering is useful when the field contains a manageable list of categories, names, products, or locations.

7.2 Advanced Filtering

Advanced filtering allows users to define conditions such as contains, does not contain, is greater than, is less than, or other supported comparisons.

Example: Show records where Sales Amount is greater than 50,000.

Available conditions depend on the field's data type and the selected filter configuration.

7.3 Relative Date Filtering

Relative date filters can focus on a moving date range, such as the current month, the previous month, or the last several days, when the field and filter support relative date conditions.

Example: Show orders from the last 30 days.

Relative date filters are useful for operational dashboards that need to focus on recent activity. Check the filter's date interpretation and time zone requirements where relevant.

7.4 Top N Filtering

Top N filtering identifies a selected number of items based on a measure. It is commonly used for visual-level analysis.

Example: Show the top five products by total sales.

1. Select the relevant visual.
2. Add the Product field to the visual-level filter section if necessary.
3. Choose the Top N filter type where available.
4. Choose Top and enter 5.
5. Set the ranking measure, such as Total Sales.
6. Apply the filter and verify the results.

8. Filter Context and How Filters Work Together

Filter context determines which rows of data are considered when Power BI evaluates a visual or measure. Filter context can be affected by report-level filters, page-level filters, visual-level filters, slicers, interactions between visuals, and other model or DAX behavior.

Filters at different levels generally work together. A lower-level filter typically narrows the data within the constraints of higher-level filters rather than overriding them.

8.1 Example of Combined Filters

Suppose a report has these conditions:

• Report-level filter: Country = India.
• Page-level filter: Year = 2026.
• Visual-level filter: Product Category = Electronics.

The selected visual is evaluated using all three conditions. Its data focuses on Electronics in India during 2026, assuming the fields are related appropriately in the model.

8.2 Filter Scope Example

8.3 Why a Filter May Not Produce the Expected Result

• The field may come from a table that is not related correctly to the table supplying the visual's values.
• Another filter may restrict the same field to a different value.
• A measure may intentionally remove or modify certain filters using DAX functions.
• The field may have unexpected data types or blank values.
• Interactions between visuals may add additional filtering or highlighting.
• The selected filter type or condition may not match the intended requirement.

9. Filters Versus Slicers

Filters and slicers both help users narrow the data displayed in a report, but they are used in different ways.

A filter is commonly configured in the Filters pane. A slicer is a visual control placed on the report canvas, allowing users to make selections directly on the page.

Slicers can be synchronized across report pages when that behavior is configured. A page-level filter, by contrast, does not automatically synchronize its selection to other pages.

10. Creating a Practical Sales Report

In this exercise, create a report that demonstrates all three filter levels using a simple sales dataset.

10.1 Sample Dataset

10.2 Create a Total Sales Measure

After importing the data, create a DAX measure to calculate total sales:

Total Sales =
SUM(Sales[Sales])

This example assumes the imported table is named Sales and its numeric column is also named Sales. If the column or table has a different name, adjust the formula accordingly.

10.3 Build the Report Page

1. Add a card visual displaying Total Sales.
2. Add a column chart showing Total Sales by Region.
3. Add a bar chart showing Total Sales by Category.
4. Add a line chart showing Total Sales by Year or Month if the dataset contains suitable date information.
5. Rename the page to Sales Analysis.

10.4 Apply a Report-Level Filter

1. Drag Country into Filters on all pages.
2. Select India.
3. Check the card and charts on the current page.
4. Navigate to another report page and confirm that the country restriction is also applied there.

10.5 Apply a Page-Level Filter

1. On the Sales Analysis page, drag Year into Filters on this page.
2. Select 2026.
3. Review all visuals on the page.
4. Confirm that the page displays data for the selected year while the report-level country restriction remains active.

10.6 Apply a Visual-Level Filter

1. Select the Category bar chart.
2. Drag Category into Filters on this visual if it is not already present.
3. Select Electronics.
4. Confirm that the selected chart now focuses on Electronics.
5. Check the other visuals on the page; the visual-level filter should not directly restrict those other visuals.

10.7 Expected Result

The report-level filter restricts the report to India. The page-level filter restricts the Sales Analysis page to 2026. The visual-level filter restricts the selected category chart to Electronics.

The combined result demonstrates how Power BI filters can be used at different scopes to answer different business questions without adding unnecessary pages or separate reports.

11. Managing, Editing, and Clearing Filters

After applying filters, report designers may need to modify conditions, remove fields, or restore the original view.

11.1 Editing a Filter

1. Locate the relevant filter card in the Filters pane.
2. Expand the card.
3. Change the selected values or condition.
4. Review the affected visual, page, or report.

11.2 Removing a Filter

1. Locate the filter card you want to remove.
2. Use the available clear or remove control, depending on the interface.
3. If you want to remove the field entirely from the filter scope, remove the field from that filter section.
4. Verify the resulting data.

11.3 Resetting Filters in the Power BI Service

In the Power BI service, report readers may be able to reset the report to its default state using the Reset to default option, depending on the report experience and permissions. The default state is determined by the report author's saved configuration.

Resetting a report is different from clearing one filter card. Always confirm whether you intend to clear a single condition or restore the report's default view.

12. Filter Formatting and User Experience

Filter cards can be configured to improve the report's usability. Available options depend on the Power BI interface and the type of filter.

12.1 Useful Filter Settings

• Rename: Use a meaningful display name for the filter where supported.
• Hide: Hide a filter card from the reader when appropriate and supported.
• Lock: Prevent users from changing a filter when the interface supports filter locking.
• Reorder: Arrange filter cards logically where supported.
• Basic or advanced filtering: Configure the appropriate filter experience for the field.
• Search: Help users find values in long lists when search is available.

12.2 Filter Design Best Practices

• Use clear field names and avoid unexplained abbreviations.
• Keep the most important filters easy to locate.
• Use report-level filters only for conditions intended to apply throughout the report.
• Use page-level filters to establish a clear focus for one page.
• Use visual-level filters for chart-specific requirements.
• Avoid applying unnecessary or conflicting filters at multiple levels.
• Test the report in reading mode to understand the reader's experience.

13. Common Mistakes When Using Filters

14. Troubleshooting Filter Issues

14.1 A Visual Does Not Change After Applying a Filter

Possible causes:

• The selected field is not related correctly to the data used by the visual.
• The filter condition matches all available records.
• A measure changes the expected filter behavior.
• The filter was applied to a different visual than intended.

Solutions:

1. Confirm the filter's location and scope.
2. Inspect the data model relationships.
3. Check the field's values and data type.
4. Test the visual using a simple measure or table.
5. Review the DAX formula if the measure modifies filter context.

14.2 A Page-Level Filter Affects Only Some Expected Data

Some visuals may use different tables, measures, or relationship paths. Check whether the filter field can propagate to the data used by each visual. Also review measures that use DAX functions to modify filter context.

14.3 A Report-Level Filter Causes Blank Visuals

A report-level filter may exclude all records relevant to a particular visual. Review the selected value, any page-level or visual-level conditions, and the relationships between the filtered field and the visual's data.

14.4 Filter Selections Reappear Later

The Power BI service may retain a reader's filtering state between sessions, depending on the report experience. Use the available reset option to return to the report's default state when necessary.

15. Filters and Row-Level Security

Filters and Row-Level Security (RLS) serve different purposes. Filters help users analyze a subset of data in a report. RLS is a data-model security feature that restricts which rows a user is authorized to access, based on the configured security roles and identity.

Do not rely on hidden filter cards or report-level filters as a security mechanism. Configure and test the appropriate security controls when data access must be restricted.

16. Best Practices for Choosing the Correct Filter Level

• Use a visual-level filter when only one visual needs a specific subset of data.
• Use a page-level filter when all relevant visuals on one page should share a condition.
• Use a report-level filter when the same condition should apply throughout the report.
• Use slicers when users need visible, interactive selection controls.
• Use synchronized slicers when the same selection should be available across multiple pages.
• Check interactions between visuals when selections affect other charts.
• Review filter context when measures return unexpected values.
• Use meaningful labels and keep the filtering experience easy to understand.
• Verify the report after applying filters at multiple levels.
• Use RLS and appropriate permissions for security instead of ordinary filters.

17. Practical Exercise: Regional Sales Dashboard

Create a dashboard for a sales manager who needs to analyze company performance by country, year, region, and product category.

17.1 Requirements

• Create a card showing Total Sales.
• Create a chart showing Sales by Region.
• Create a chart showing Sales by Category.
• Create a table showing sales transactions.
• Apply a report-level filter to restrict the report to a selected country.
• Apply a page-level filter to focus one page on a selected year.
• Apply a visual-level filter to show a selected product category in one chart.
• Add a slicer for interactive region selection if required.

17.2 Testing Tasks

1. Change the report-level country filter and inspect every page.
2. Change the page-level year filter and verify the active page.
3. Change the visual-level category filter and verify that only the intended visual receives that filter.
4. Clear one filter and observe how the result changes.
5. Inspect the total displayed by the card and confirm that it matches the active filter context.
6. Test the report as a reader if possible.

17.3 Learning Outcome

After completing the exercise, you should understand how filter scope changes the data displayed in a report and how multiple filters combine to support focused business analysis.

18. Interview Questions and Answers

Q1. What is a filter in Power BI?

Answer: A filter restricts the data used by a visual, report page, or report so that users can focus on specific records or values.

Q2. What are the three main filter levels in Power BI?

Answer: Visual-level filters, page-level filters, and report-level filters.

Q3. What is a visual-level filter?

Answer: It applies to a single visual, such as a chart, table, or card.

Q4. What is a page-level filter?

Answer: It applies to the relevant visuals on one report page.

Q5. What is a report-level filter?

Answer: It applies across the report's pages and affects relevant visuals throughout the report.

Q6. Can a visual-level filter affect other visuals directly?

Answer: A visual-level filter applies to its selected visual. Other visuals may still be affected by separate filter settings or interactions, but the visual-level filter itself does not automatically become a filter on all other visuals.

Q7. Can different report pages have different page-level filters?

Answer: Yes. Each page can have its own page-level filters.

Q8. What happens when report-level and page-level filters are both applied?

Answer: The conditions generally combine. The page is evaluated within the report-level filter context, and page-level filters narrow the data further.

Q9. What is the difference between filters and slicers?

Answer: Filters are commonly configured in the Filters pane, while slicers are visible report visuals that let users select values directly on the canvas.

Q10. What is basic filtering?

Answer: Basic filtering lets users select specific values from a list of available field values.

Q11. What is advanced filtering?

Answer: Advanced filtering lets users apply conditions such as greater than, contains, or other supported comparisons.

Q12. What is Top N filtering?

Answer: Top N filtering selects a specified number of items ranked by a measure, such as the top five products by sales.

Q13. Why might a filter not affect a visual?

Answer: The field may not be related correctly to the visual's data, the condition may match all records, or a measure may modify filter context.

Q14. Do filters provide data security?

Answer: No. Ordinary report filters are not a replacement for security controls. Use appropriate permissions and Row-Level Security when access to data must be restricted.

Q15. How can a report reader restore the default filter state?

Answer: In supported Power BI service experiences, the reader can use Reset to default to restore the report's saved default state.

19. Quick Revision Checklist

• Understand the purpose of the Filters pane.
• Know the difference between visual-level, page-level, and report-level filters.
• Use visual-level filters for one visual.
• Use page-level filters for one report page.
• Use report-level filters for the entire report.
• Understand how filter conditions combine.
• Know when to use basic, advanced, relative date, and Top N filtering.
• Distinguish filters from slicers.
• Check relationships and DAX behavior when results are unexpected.
• Use RLS rather than ordinary filters for data security.

20. Learning Outcomes

After studying this topic, learners should be able to:

• Explain the purpose of filters in Power BI.
• Locate and use the Filters pane.
• Create and manage visual-level filters.
• Apply page-level filters to report pages.
• Apply report-level filters across multiple pages.
• Combine filter conditions for focused analysis.
• Distinguish filter types and choose the appropriate one.
• Troubleshoot common filtering issues.
• Design reports with clear and consistent filtering behavior.

21. Official Learning Resources

• Microsoft Learn: Filters and Highlighting in Power BI Reports
• Microsoft Learn: Add a Filter to a Report in Power BI
• Microsoft Learn: Report Drillthrough Guidance
• JustAcademy: Microsoft Power BI Training
• JustAcademy: Register for a Course Demo

22. Conclusion

Visual-level, page-level, and report-level filters are fundamental features for building interactive Power BI reports. Visual-level filters focus on one visual, page-level filters establish a common condition for one page, and report-level filters provide a shared filtering context throughout the report.

Choosing the correct filter scope, understanding how conditions combine, and checking relationships and measure behavior help ensure that reports display meaningful and accurate results. With practice, these techniques make it easier to create clear, flexible, and useful business intelligence reports.

Explore More: Visit JustAcademy, explore the Microsoft Power BI Training course, or register for a course demo.