How to Use Filter Function in Power BI

Slicing through your data to find exactly what you need is the whole point of data analysis, and Power BI’s filter function is your primary tool for the job. Knowing how to filter correctly transforms a cluttered dashboard into a clear, focused story. This guide will walk you through the types of filters available in Power BI, how and when to use them, and some practical tips to make your reports cleaner and more interactive.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Filtering Matters in Power BI

Filtering in Power BI isn't just about removing unwanted data - it's about creating context and providing focus. When you're looking at a massive dataset with sales from every region, every product, and every year, it's virtually impossible to spot a meaningful trend. Filtering allows you to isolate specific variables to answer direct questions like:

• How did our sales in the Northeast region perform in the last quarter?
• Which products are our top 10 sellers this month?
• What does website traffic from mobile devices look like specifically?

By applying filters, you narrow the scope of your data, making your charts, graphs, and tables instantly more understandable and actionable. It's the difference between looking at a map of the entire world and looking at a detailed street map of your neighborhood when you’re trying to find a local coffee shop.

Understanding the Power BI Filters Pane

The control center for all your filtering activities is the Filters pane, which typically sits on the right side of your Power BI Desktop window, next to the Visualizations and Data panes. If you don't see it, go to the View tab in the top ribbon and make sure the "Filters" checkbox is ticked.

The pane is context-sensitive. What you see inside it changes based on what you’ve selected on your report canvas. For example, if you haven’t clicked on anything, you’ll only see options for page-level and report-level filters. If you click on a specific bar chart, a new section will appear for applying filters to that specific visual.

Each field you add to the pane becomes a "filter card," where you can select the filtering mode (like Basic or Advanced) and make your specific selections.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Different Levels of Power BI Filters

Understanding the different scopes, or levels, of filtering is the most important concept to grasp. Power BI offers three main levels, letting you control what gets filtered with incredible precision.

1. Visual-Level Filters

A visual-level filter applies only to a single, selected visual on your report page. This is your go-to when you want one chart to show something different from the others. It’s perfect for creating highly specific visuals that support the broader story told on the page.

Example Scenario: You have a sales dashboard. One big KPI card shows total revenue, and a bar chart shows sales by region. You want to add another bar chart that only displays sales from your top 5 revenue-generating products, without affecting any other visuals.

How to apply a visual-level filter:

1. Click on the specific visual you want to filter (in this case, your new bar chart for products).
2. In the Filters pane, you'll now see a section called "Filters on this visual."
3. From the Data pane, find the field you want to filter by - let's use "Product Name" - and drag it into the "Filters on this visual" box.
4. A filter card will appear. For this example, you'd change the Filter type to "Top N."
5. Set it to "Top 5" and then drag your "Sales Amount" field into the "By value" box.
6. Click "Apply filter."

Now, this specific chart shows only your top 5 products, while every other visual on the page remains an unfiltered view of all your data.

2. Page-Level Filters

A page-level filter applies to all the visuals on a single report page. This is incredibly efficient for creating themed pages dedicated to a specific category, region, time period, or brand.

Example Scenario: Your sales report has multiple pages. You decide to dedicate one entire page to analyzing performance from the previous year, 2023. You want every chart, map, and table on this page to reflect only 2023 data.

How to apply a page-level filter:

1. Make sure no visuals are selected by clicking on the blank background of the report canvas.
2. Look at the Filters pane. You will see a section named "Filters on this page."
3. From the Data pane, find the "Order Date" field and drag it into the "Filters on this page" area.
4. A date filter card will appear. You can use Advanced filtering to set the date range to be after 01/01/2023 and before 31/12/2023. A simpler way is to use "Relative date filtering" and choose "is in the year" 2023, though this isn't dynamic. A basic filter would show you a checklist of all years.
5. Once you apply this filter, every visual on the page automatically updates to show only 2023 data.

3. Report-Level Filters

This is the broadest filter type. A report-level filter applies to all pages and all visuals in your entire report. It’s the ultimate "master" filter, ideal for situations where the entire report needs to be viewed through a single lens.

Example Scenario: You are creating a version of the corporate sales report specifically for the marketing director of Canada. They don't need to see sales data from any other country, as it’s not relevant to them. Applying a report-level filter ensures consistency and focus across the board.

How to apply a report-level filter:

1. Again, make sure no visuals are selected by clicking on the canvas background.
2. In the Filters pane, locate the section called "Filters on all pages."
3. From the Data pane, find the "Country" field and drag it into this section.
4. Select "Canada" from the list of countries.
5. The filter is now active. Every single chart, on every single page, will now only show data where the country is Canada.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Exploring Filter Types: Basic, Advanced, and More

Within each filter level (visual, page, or report), you get different methods for applying the filter logic. After you drag a field into the Filters pane, you can expand its card and select a "Filter type."

Basic Filtering

This is the default setting for most text-based fields. It presents you with a simple list of all the available values in that field, each with a checkbox. You just scroll through and check the ones you want to include. It's straightforward and perfect for when you need to select a handful of specific items like product categories or city names.

Advanced Filtering

For more control, you can switch to "Advanced filtering." This lets you create rules. It's useful for text, numbers, and dates. For text fields, you get options like:

• Contains
• Does not contain
• Starts with
• Is blank

For numeric fields, you'll see options like "Is greater than," "Is less than or equal to," or "Is not."

You can even add multiple conditions using "And" or "Or" operators. For example, you could filter your customers to show only those where City is New York AND Lead Source contains Web.

Top N Filtering

This is a quick and powerful way to isolate top or bottom performers without complex manual formulas. You could, for instance, configure a filter to show your:

• Top 10 Products by Revenue
• Bottom 5 Campaigns by Cost Per Acquisition (CPA)
• Top 3 Sales Reps by Deal Count

You simply select Top or Bottom, input the number you want to see (e.g., 10), and then drag the measure you want to evaluate by (e.g., Revenue) into the "By value" field.

Relative Date Filtering

For any date field, this is often the most useful in day-to-day business reporting. Instead of manually selecting a static date range like "August 1 to August 31," you can set dynamic time windows that automatically update. Some popular choices include:

• Is in the last _ days/weeks/months/years
• Is in this _ day/week/month/year
• Is in the next _ day/week/month/year

Using a filter like "in the last 30 days" ensures your report is always current every time it’s refreshed, with no manual changes needed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pro Tips for Effective Filtering

Knowing the mechanics is one thing, using them effectively is another. Here are a couple of best practices.

Lock or Hide Filters from Your Audience

As a report creator, you may set certain filters to establish a baseline view you don’t want your end-users to change. You can lock a filter to prevent them from editing it, or even hide the filter card entirely so they don't see it in their view. This is useful for cleaning up the interface and preventing accidental misinterpretation of the data.

Use Slicers for Interactive Filtering

While the Filters pane is great for you, the developer, it’s not always the most intuitive interface for your audience. For common filter choices you want to give your users control over - such as year, region, or product line - use a Slicer visual instead. Slicers sit directly on the report canvas as buttons, dropdowns, or sliders, providing a much more user-friendly filtering experience.

Final Thoughts

Mastering Power BI filters - from the different levels of visual, page, and report to the specific types like advanced, Top N, and relative dates - is fundamental to creating dynamic and insightful reports. It's how you move from simply showing data to guiding your audience toward clear, focused answers that drive better decisions.

Building layered reports in a tool like Power BI is a critical skill, but it often involves a lot of trial-and-error with fields and filter settings. At Graphed, we redesigned that experience from the ground up. We let you skip the manual drag-and-drop and just describe what you want to see, like "Show me a chart of our top selling products compared to last month in Germany." The appropriate filters are applied automatically, and a real-time dashboard is generated in seconds. If Power BI feels too complex, give Graphed a try and see how easy it is to focus on your data's story, not the tool's complexity.