How to Filter Data in Power BI
Filtering data is one of the most fundamental skills for turning a crowded dashboard into a clear, insightful report. If you're building reports in Power BI, you need to know how to slice and dice your information to answer specific business questions. This guide will walk you through exactly how to apply filters in Power BI, covering the essential types and providing practical, step-by-step instructions.
What is Filtering in Power BI?
Filtering in Power BI is the process of hiding data you don't need to see, allowing you to focus on a specific subset of your information. Think of it like a sieve for your data. You start with a massive amount of information - every sale, every website visit, every customer support ticket - and then apply filters to narrow it down to what's relevant to your immediate question.
Without filtering, you might be looking at total company sales worldwide for all time. With a few filters, you can instantly answer questions like:
- What were the sales for our "Mountain Bike" category in Germany during the last quarter?
- Which ten products had the highest return rate this month?
- How many new customers did we acquire through our Facebook ad campaign last week?
Effectively using filters moves you from data overload to clear, actionable insights, which is the entire purpose of building a dashboard in the first place.
Understanding the Power BI Filters Pane
The primary control center for filtering in Power BI is the Filters pane. This is typically located on the right side of your screen in Power BI Desktop. If you don't see it, you can enable it by going to the View tab in the top ribbon and checking the box for Filters.
The Filters pane looks a bit different depending on whether you're using the modern or classic view, but its functionality is the same. It's divided into distinct sections based on the scope of the filter you want to apply:
Filters on This Visual
When you select a single chart, table, or any other visual on your report canvas, this section appears. Any field you drag into this area will apply a filter only to that specific visual. This is perfect when you want one chart to show data for North America, for example, while another chart on the same page continues to show global data.
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.
Filters on This Page
Fields added to this section will apply a filter to all the visuals on the current report page. It's a convenient way to analyze a page focused on a single theme, like a specific marketing campaign, a product line, or a sales region. Setting a "Year = 2023" filter here ensures every chart on the page reflects data only from 2023.
Filters on All Pages
As the name suggests, any filter applied here affects every single page in your entire report. This is used for high-level filters you want to maintain consistently, such as filtering out test data, focusing on a specific business unit, or setting a global date range for a monthly report. Use this with caution, as it can easily be forgotten and lead to misinterpreted data on other pages.
Types of Power BI Filters
Once you drag a field into the Filters pane, Power BI offers several methods for filtering it. The type of field you are working with (text, number, or date) will determine which options are available.
1. Basic Filtering
This is the simplest way to filter. For categorical data like product names, countries, or employee names, basic filtering presents a list of all available values with a checkbox next to each one. You simply scroll through the list and check the boxes for the values you want to include.
Example: You have a sales report and want to see data only for "USA" and "Canada." You would drag the "Country" field to the "Filters on this page" section, select "Basic filtering," and check the boxes next to USA and Canada.
2. Advanced Filtering
For more specific conditions, advanced filtering allows you to create rules. Instead of just selecting from a list, you can specify text or numeric conditions. You can also combine multiple rules using "And" and "Or" logic.
Common conditions for a text field include:
- Contains: Shows values that include a particular word or phrase.
- Starts with: Narrows down to values that begin with specific characters.
- Is not blank: Hides any entries that are empty.
For a numeric field such as "Revenue" or "Quantity," you can use rules like:
- Is greater than: Shows values above a certain number.
- Is less than or equal to: Displays values below or at a certain threshold.
- Is not: Excludes a specific number.
Example: To find all sales where the order quantity was greater than 100, you would drag the "Quantity" field, choose "Advanced filtering," set the condition to "is greater than," and type "100" in the value box.
3. Relative Date/Time Filtering
One of the most powerful features for business reporting is relative date filtering. This lets you filter your data based on a time period relative to today, such as "in the last 30 days" or "in this year." This is incredibly useful for creating dashboards that automatically update to show current performance without needing manual adjustments.
You can choose from periods like:
- Last/This/Next...
- Days, Weeks, Months, Years
Example: To create a chart that always shows sales from the current month, you'd drag the "Order Date" field to the Filters pane, select "Relative date," and set the filter to show items "in this month." On December 1st, it will show December data, on January 1st, it will automatically switch to show January data.
4. Top N Filtering
This filter lets you find the metaphorical "Top 10" performers, though you can set any number you like. This is used to display a subset of your data based on a ranking measure, such as finding your best-selling products or worst-performing ad campaigns.
When you set up a Top N filter, you need two things:
- The number you want to show (e.g., 10, 5, 20).
- The field that defines "best" or "worst" (the measure, e.g., "by Total Sales").
Example: To create a chart showing your 5 best-selling products, you would drag the "Product Name" field to the Filters pane. Then, select "Top N," enter "5" in the box, and finally, drag your "Total Sales" measure into the "By value" field.
Applying Your First Filter: A Step-by-Step Walkthrough
Ready to try it? Let’s walk through applying a simple filter together. Imagine we have a sales report and we want to create a bar chart that shows sales for laptops and smartphones in the United States only.
Step 1: Open the Filters Pane
First, make sure the Filters pane is visible on the right side of Power BI Desktop.
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.
Step 2: Select Your Visual
Click on the bar chart you've created to select it. You will see the "Filters on this visual" section appear at the top of the Filters pane.
Step 3: Add Your Category Filter
From your Fields list, find your "Product Category" field and drag it into the "Add data fields here" box inside the "Filters on this visual" area.
Step 4: Configure the Basic Filter
Your filter settings will appear. Make sure the filter type is set to "Basic filtering." Scroll down the list of categories and check the boxes next to "Laptop" and "Smartphone." The chart on your canvas will immediately update to show only those two categories.
Step 5: Add a Geography Filter (to the whole page)
Now, let's filter the entire page to the United States. Find your "Country" field and drag it into the "Filters on this page" area. Once again, select "Basic filtering" and check the box next to "United States." Now, your bar chart (and any other visuals on the page) will only show data for laptop and smartphone sales that happened in the US.
Tips and Best Practices
As you get more comfortable, keep these tips in mind to build more effective and user-friendly reports.
- Lock and Hide Filters: When sharing a report, you may have applied filters you don't want your audience to change. Each filter has a small lock icon. Clicking this prevents users from modifying the filter. There is also an eye icon to hide the filter entirely, decluttering the view and preventing confusion.
- Use Slicers for Interaction: While the Filters pane is great for report builders, a Slicer is a more user-friendly way for viewers to filter data directly on the page. A Slicer is a type of visual that provides on-canvas filtering with buttons or dropdowns. It's often better to expose common choices (like year or product line) as slicers rather than asking users to open the Filters pane.
- Be Mindful of Performance: Applying many complex filters, especially using advanced conditions with "contains" on very large datasets, can slow down report performance. Try to filter on numeric or fixed-code columns where possible and simplify your logic if a report feels sluggish.
Final Thoughts
Mastering filtering is a non-negotiable skill for anyone serious about creating meaningful reports in Power BI. Understanding the different scopes - visual, page, and report - and knowing when to use basic, advanced, or Top N filters will empower you to isolate a precise signal from the noise of big data.
Of course, building reports in tools like Power BI still involves a lot of manual dragging, dropping, and configuring before you see the result. At Graphed, we created a faster way. Instead of wading through menus and panes, you can just connect your data and ask in plain English, "show me a bar chart of our top 5 products by sales in the US for last quarter." We instantly build a live, interactive dashboard that answers your question, turning hours of report-building busywork into a 30-second conversation.
Related Articles
Facebook Ads For Dental Practices: The Complete 2026 Strategy Guide
Learn how to effectively use facebook ads for dental practices to attract new patients to your dental practice. This comprehensive 2026 guide covers targeting, budgeting, creative strategies, and ROI expectations.
Test: Facebook Ads For Dentists 2026
Test excerpt
Facebook Ads for Landscapers: The Complete 2026 Strategy Guide
Learn how to run profitable Facebook ads for landscapers in 2026. This complete guide covers audience targeting, ad formats, budgeting, and optimization strategies to generate leads at $30-50 per lead.