How to Use Text Filter in Power BI

Filtering your data is one of the most fundamental tasks in Power BI, and mastering text filters can turn a cluttered report into a crystal-clear story. Instead of showing everything at once, text filters allow you to zero in on specific categories, products, regions, or any other dimension you need to analyze. This guide will walk you through exactly how to use text filters in Power BI, from simple selections to more advanced-level conditions.

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

Slicers vs. the Filters Pane: What's the Difference?

Before we go deeper, it's important to understand the two main ways to filter in Power BI. While they can achieve similar results, they are designed for different purposes.

• Slicers: These are interactive, on-canvas visuals (like buttons or dropdowns) that you add directly to your report. They are designed for end-users to easily click and filter the data themselves. Think of a slicer as a user-friendly remote control for the report page.
• The Filters Pane: This is a dedicated pane, typically on the right side of the Power BI Desktop interface. It offers more powerful and complex filtering options. It's primarily used by report creators during the design phase but can also be made available to end-users to modify.

This article will focus on using the Filters Pane because it provides the most comprehensive text filtering capabilities you'll need as you build your reports.

Filter Levels in the Filters Pane

Within the Filters Pane, you can apply filters at three different levels, which determines their scope:

1. Filters on this visual: The filter only affects one specific chart or table that you have selected.
2. Filters on this page: The filter affects all visuals on the current report page.
3. Filters on all pages: The filter applies globally across every page in your entire PBIX report.

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

How to Apply Basic Text Filters

Let's start with the most common and straightforward way to filter text: basic filtering. This mode lets you select values from a list, much like checking boxes.

Imagine you have a sales report and you only want your bar chart to show the performance for "Laptops" and "Smart Watches".

Here's how you'd do it step-by-step:

1. Select Your Visual: Click on the bar chart you want to filter. This will activate the "Filters on this visual" section in the Filters Pane.
2. Add the Text Field: Find your text field in the "Data" pane (for our example, this would be a field named "Product Category"). Drag and drop "Product Category" into the "Filters on this visual" area.
3. Choose Your Values: Power BI will automatically display a filter card for "Product Category" in "Basic filtering" mode. You'll see a list of all available categories. Simply check the boxes next to "Laptops" and "Smart Watches".

That's it! Your bar chart will immediately update to show data only for those two selected categories. If you have a long list of values, you can use the small search bar within the filter card itself to quickly find the items you're looking for.

Using Advanced Text Filtering Conditions

Basic checkbox filtering is great for simple selections, but what if your logic is more complex? This is where "Advanced filtering" comes in. It allows you to create rules based on conditions like "contains," "starts with," and more.

To access it, click the "Filter type" dropdown within your text filter card and select Advanced filtering.

Here you'll see fields to build your rules:

• Show items when the value: This is where you set your condition.
• And / Or: This allows you to combine two rules for more specific filtering.

Let's look at each condition with a practical example.

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

Contains / Does Not Contain

This is arguably the most useful condition. It finds text that includes a certain substring.

• Contains: You want to see all products that are some variation of "Pro".
• Does not contain: You want to exclude any basic or entry-level products.

Starts With / Does Not Start With

This is perfect for when you know the beginning of the text string you're looking for.

• Starts with: You need to filter a customer list to find everyone whose first name begins with an "A".
• Does not start with: You want to hide all internal sales codes, which always begin with "INT".

Is / Is Not

This condition looks for an exact match. It's stricter than "contains."

• Is: You need to show data for one specific country, and only that country.
• Is not: You need to show performance for all regions except one.

Is Blank / Is Not Blank

This powerful condition helps you find data that is missing or present.

• Is blank: You're looking for customer records that don't have a sales representative assigned.
• Is not blank: You only want to analyze orders where a coupon code was used.

Combining Rules with AND / OR

You can make your filtering even more precise by using a second condition with the "And" or "Or" operators.

• Using And: You want to find "Pro" laptop models, but exclude the "Mini" version.
• Using Or: You want to analyze sales from both the North and South American regions.

Filtering Text with the "Top N" Option

While often used for numerical values, the "Top N" filter type can be incredibly useful for text fields when combined with a measure.

For example, you can easily find your top 10 best-selling products without creating complex DAX formulas.

1. In the filter card for your "Product Name" field, change the "Filter type" to Top N.
2. In the "Show items" dropdown, choose Top (or Bottom).
3. Enter the number you want to see, for instance, 10.
4. Now, you need to tell Power BI what to base this ranking on. Drag a measure, like Sales Amount from your "Data" pane, into the By value field.
5. Click Apply filter.

Your visual will now display only the 10 products with the highest total sales.

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

Important Tips for Text Filtering

• Filtering is NOT case-sensitive. When you filter for text that "contains" pro, Power BI will find "Pro", "pro", and "PRO". You don't need to worry about capitalization.
• Performance Matters. Filtering by 'contains' on a field with millions of unique text values in DirectQuery mode can slow down your report. 'Starts with' or simple 'is' filters are generally faster. If performance becomes an issue, try to be as specific as possible.
• Think About User Experience. If a filter needs to be changed often by your audience, consider adding a Slicer to the report canvas instead of burying it in the Filters Pane.

Final Thoughts

Mastering text filters in Power BI is essential for digging into your data and presenting only what's most relevant. By moving from basic check-box selections to advanced conditions and Top N filtering, you can precisely control what your reports show, helping you uncover more meaningful insights without getting overwhelmed by noise.

While tools like Power BI are incredibly powerful, we know that building reports - and mastering all their features - takes time. Often, you just need a quick answer without getting bogged down in filter panes and visual configurations. That's why we created Graphed. We connect directly to your data sources and allow you to build dashboards by simply describing what you want in plain English. Instead of manually applying filter after filter, you can just ask, "Show me my top 10 products by sales in Canada for last quarter," and get an interactive dashboard, instantly.