How to Add a Filter in Power BI Report Builder

Building a report that shows everything can be overwhelming, but adding filters transforms a wall of data into a sharp, focused story. If you're using Power BI Report Builder to create paginated reports, filters are your most powerful tool for making data clear and actionable. This guide will walk you through exactly how and where to add filters, from basic setup to dynamic, user-driven controls.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Filters Are Essential in Power BI Reports

Before we jump into the "how," let's quickly cover the "why." Filters aren't just about hiding data, they're about enhancing it. By showing only what's relevant, you make your reports more valuable for everyone who uses them.

• Clarity and Focus: Instead of showing global sales for all time, a filter can narrow the report to "sales in California for the last quarter." This helps your audience immediately grasp the key information without being distracted by irrelevant data.
• Improved Performance: When you filter data at the dataset level, Report Builder has to process and render less information. This can dramatically speed up report generation, especially with large datasets, providing a much better user experience.
• Personalized User Experience: By linking filters to parameters, you empower users to select what they want to see. A sales manager can select their own region, or a marketing manager can choose a specific campaign, making one report serve many different needs.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Understanding the Three Levels of Filtering

In Power BI Report Builder, you can apply filters in three main places. Knowing where to add your filter is just as important as knowing how to create it. Your choice depends on what you want to achieve with your report.

1. Dataset Filters: This is the most common and often the most efficient place to filter. When you apply a filter at the dataset level, you are filtering the data before it's even used by the report's tables, charts, or other elements. This reduces the amount of data the report needs to handle, improving performance.

• When to use it: Use a dataset filter when you know you want to exclude certain data from the entire report. For example, filtering out test accounts or inactive customer records.

2. Data Region Filters (Tables, Matrices, Charts): A "data region" is just a visual element like a table, matrix, or chart that displays your data. You can apply filters directly to these individual elements. In this case, the full dataset is loaded, but each data region only shows a subset of it based on its own filter rules.

• When to use it: Use data region filters when you need to show different "slices" of the same data in one report. For example, having one chart show data for North America and a separate chart showing data for Europe, all pulling from the same global sales dataset.

3. Group Filters (in Tables or Matrices): If you have data grouped within a table or matrix (e.g., grouping sales by country), you can apply a filter specifically to the group. This allows you to include or exclude entire groups of records based on an aggregate condition.

• When to use it: This is for more advanced scenarios, like when you only want to show product categories where the total sales are greater than $10,000. You are filtering based on a calculation, not a static value.

Step-by-Step Guide: How to Add a Filter to a Dataset

Let's walk through the most common scenario: adding a filter directly to your dataset. For this example, we'll imagine we have a sales report and we only want it to show data for sales made in "Canada."

1. Open the Dataset Properties

First, find the Report Data pane, which is usually on the left side of your screen. If you don't see it, go to the "View" tab on the ribbon and make sure "Report Data" is checked. Under the "Datasets" folder, right-click on the dataset you want to filter and select Dataset Properties.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

2. Navigate to the Filters Tab

In the "Dataset Properties" window, click on the Filters tab on the left-hand menu. This is where you'll define all the rules for filtering this dataset.

3. Add a New Filter Condition

Click the Add button. This creates a new blank filter row with three parts you need to configure: Expression, Operator, and Value.

4. Define the Filter Condition

• Expression: This is the field you want to filter by. Click the dropdown and select the field from your dataset. In our example, we'd choose the [Country] field.
• Operator: This defines the type of comparison. The default is equals (=), which is what we need. Other common options include "Not Equal To" (<>), "Greater Than" (>), or "Like" for partial text matches. We will stick with =.
• Value: This is what you're comparing against. Here, you would type the value you want to see. Since we want to see sales in Canada, we will type "Canada". It's important to wrap text values in double quotes.

Your completed filter condition should look like this:

Expression: [Country] Operator: = Value: "Canada"

5. Save and Run Your Report

Click OK to close the Dataset Properties window. Now, go to the "Home" tab on the ribbon and click Run. Your report will now generate, but it will only contain data where the "Country" field is "Canada." All other data has been filtered out.

How to Filter a Specific Table or Chart (Data Region Filter)

What if your dataset contains global sales, and you want to keep it all, but you want to create one table showing only "United Kingdom" sales? This is a perfect use case for a data region filter.

1. On your report canvas, click on the table, matrix, or chart you want to filter. This will highlight it with a border.
2. Right-click on the small grey square handle in the top-left corner of the selected object (this is the tablix handle) and select Tablix Properties. (If it's a chart, it will say "Chart Properties," etc.).
3. Just like before, go to the Filters tab in the properties window.
4. Click Add and set up your filter condition just as you did for the dataset filter. For our example:
5. Click OK. Now, when you run the report, the dataset will pull all your global sales data, but this specific table will only display the rows for the United Kingdom.

Advanced Techniques: Using Parameters for Dynamic Filters

Static filters are useful, but the real power comes from letting your users choose what they want to see. You can do this by linking a filter to a report parameter.

A parameter creates an input control (like a dropdown menu or a text box) on the report. When a user selects a value, that value is passed into your filter.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Quick Guide to Creating a Parameter-based Filter

Let's set up a country selector for our report.

1. First, create the parameter. In the Report Data pane, right-click the "Parameters" folder and select Add Parameter.
2. Give it a name (e.g., CountryParameter) and a prompt (e.g., "Select a Country:"). For available values, you could provide a static list (e.g., "Canada", "USA", "UK") or get values from a dataset query.
3. Now, go back to your filter setup (either on the Dataset Properties or the Tablix Properties).
4. Set the "Expression" and "Operator" like before ([Country] and =).
5. For the "Value" field, instead of typing a static value like "Canada," click the expression button (fx). This opens the Expression Editor.
6. In the Expression Editor, navigate to "Parameters" and double-click your new CountryParameter. The editor will auto-fill with the correct expression, which looks like this:

=Parameters!CountryParameter.Value

1. Click OK on all windows.

Now, when you run the report, you'll see a dropdown menu labeled "Select a Country:". Whatever country the user chooses will be used to filter the data in real-time.

Final Thoughts

Learning how to add filters is a fundamental skill that elevates your work in Power BI Report Builder. Whether you're filtering at the dataset, data region, or group level, the goal is the same: to create clear, targeted, and user-friendly paginated reports that provide real value instead of just data dumps.

This process of opening properties windows, setting up expressions, and configuring parameters is powerful, but it's also exactly the kind of manual, multi-step busywork we built Graphed to solve. We believe getting insights shouldn't require navigating complex interfaces. With our tool, you can connect your data sources in a few clicks and build a filtered report simply by asking for what you need in plain English - like "Show me total sales for Canada, broken down by product category, for last quarter." Graphed generates a real-time, interactive dashboard in seconds, freeing you to analyze your insights instead of just building the report.