How to Filter Table in Power BI

Filtering a table cluttered with data is the first step toward finding clear, actionable insights in Power BI. Understanding how to slice, dice, and view your data from different angles is a core skill for building useful reports. This article will walk you through several ways to filter tables in Power BI, from basic pane controls and interactive slicers to powerful DAX functions.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding the Power BI Filters Pane

The simplest place to start your filtering journey is the built-in Filters pane. By default, it’s located to the right of your report page, right next to the Visualizations pane. This area is your central hub for applying rules to your data at various levels. When you select a visual, like a table, this pane dynamically shows you all the fields currently in use, ready for you to apply filters.

Here are the primary types of filters you can apply within this pane:

• Visual level filters: These apply only to a single, selected visual. If you want a specific table to show sales just for "North America" but want a nearby chart to show global sales, this is the filter you'd use.
• Page level filters: These apply to all visuals on the current report page. It's a great way to create a themed dashboard page, for instance, filtering everything to show data only for the "Q4 2023" sales period.
• Report level filters: These apply globally across all pages in your entire Power BI report. This filter is perfect for rules you always want active, such as excluding internal test data or filtering out returns from your sales analysis.
• Drill-through filters: This is a more advanced type used when you want to create a focused "detail" page that users can navigate to (or "drill through") from another visual. The context from the original visual is passed along as a filter.

Your First Steps: Basic Filtering in Power BI

Let's walk through the most common filtering task: applying a simple filter to a specific table. Imagine we have a basic sales dataset containing product categories, regions, sales amounts, and order dates.

Step 1: Create a Table Visual

First, add a Table to your report canvas by clicking the Table icon in the Visualizations pane. Then, from the Data pane, drag the relevant fields you want to display into the "Columns" well. For our example, we'll add Product Category, Region, and Sales Amount.

Step 2: Access the Filters Pane

With your new table selected, look at the Filters pane. You'll see a section called "Filters on this visual." Beneath it, you'll see listings for Product Category, Region, and Sales Amount — the fields you just added. Each one is a collapsible menu for applying filters.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Apply a Categorical Filter

Click on Product Category to expand its filtering options. Power BI defaults to "Basic filtering," which presents you with a list of all available categories and a checkbox next to each one. To show only sales for "Accessories" and "Bikes," simply check those two boxes. Your table on the canvas will instantly update to display only the rows matching that criteria.

That's it! You've successfully applied your first filter.

Going Deeper with Advanced Filtering Controls

Checkbox lists are great, but sometimes you need more sophisticated rules. This is where "Advanced filtering" comes in. If you click on the filter type dropdown (where it says "Basic filtering"), you can switch to "Advanced filtering."

This mode unlocks textual and numeric conditions. For a text field like Product Category, you can use rules such as:

• contains: Show categories that have the word "Outdoor" anywhere in the name.
• starts with: Show only categories starting with the letter "C".
• is not: Show everything except a specific category, like "Services".
• is blank: Find any sales that weren't assigned a product category.

For a numeric field like Sales Amount, you get options like is less than, is greater than or equal to, or is not. This lets you build more powerful conditioning, like filtering your table to show only sales transactions over $500.

You can even combine these rules using the And / Or logical toggles. For example, you could filter your table to show data where:

The Region is "North America" AND The Sales Amount is greater than 1000.

This combination allows you to isolate exactly the data you need for more detailed analysis without having to manipulate the underlying source data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Filtering with Slicers for Interactive Reports

Applying filters in the Filters pane is perfect for you, the report builder. But for your end users (like a manager or a sales lead), constantly navigating a hidden pane isn't intuitive. This is where Slicers come in. Slicers are user-facing filters that live directly on the report canvas, allowing anyone to interact with the data dynamically.

Step 1: Add a Slicer Visual

With an empty space selected on your report canvas, click the Slicer icon in the Visualizations pane (it looks like a funnel). An empty Slicer box will appear.

Step 2: Link the Slicer to Your Data

Just like with the table, drag a field from your Data pane into the "Field" well of the slicer. Let’s drag the Region field into it. The slicer will automatically populate with a list of unique regions from our dataset: "North America," "Europe," "Asia," etc.

Step 3: Use the Slicer

The interactivity is now live! Simply click on a region in the slicer, such as "Europe," and the main table visual (and any other visuals on the page that are linked) will instantly update to show only data for that particular region. You can turn on multi-select easily in the Slicer’s formatting options.

Customizing Slicer Styles

Power BI offers several display options for slicers. Under the Format Visual settings (the paintbrush icon), you can change the Style from a vertical list to a dropdown menu, saving valuable canvas space. For date fields, it defaults to a handy "between" slider, letting users easily select a date range.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Powerful Filtering with DAX (Data Analysis Expressions)

When you outgrow the capabilities of the Filters pane and slicers, it's time to explore DAX. DAX is the formula language used in Power BI, and it gives you complete control over your data calculations. With it, you can create measures and columns that are inherently filtered, letting you build highly specific and context-aware KPIs.

The key function here is CALCULATE. This function modifies the context in which a calculation is performed, making it the perfect tool for creating various forms of measurements.

Example DAX Measure

Let’s say you want to display the total sales for only the UK. We can create this by writing a measure like this example below:

UK Sales = CALCULATE(SUM('Sales'[Sales Amount]), 'Sales'[Region] = "UK")

Let’s break this down:

• SUM('Sales'[Sales Amount]): This part totals all the entries in Sales Amount.
• 'Sales'[Region] = "UK": This is the filter. You're instructing CALCULATE to only sum those sales where the region is "UK".

By mastering core functions like CALCULATE, you can transform and filter data in your reports effectively.

Conclusion

Final thoughts: We've explored various ways to filter data in Power BI, from simple filters to advanced DAX functions. Whether you're using basic settings, interactive slicers, or custom scripts, Power BI's filtering capabilities allow you to create meaningful visualizations that offer valuable insights.

Now that you are familiar with Power BI's tools, you should feel more at ease creating and managing filtered data visualizations. Whether it's using basic settings, making use of interactive tools for user engagement, or applying advanced DAX functions, Power BI provides the tools to transform your data into actionable insights.

We have made creating customized reports simpler with Graphed, which simplifies the method and steps involved in creating customized reports with filtered conditions. Simply ask your dashboard to show your top-selling items in Canada, displayed by product type within your product categories, and let Graphed handle the heavy lifting.