Power BI Filters

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Filters in Power BI

Power BI uses the filter function more to read the data or report based on multiple criteria. There are many filters in Power BI. This tool’s most commonly used filter is as follows:

  • Visual level filters
  • Page level filters
  • Report level filters
  • Drillthrough filters
  • Applying a filter to the visual level
  • Applying a filter to the page level

For example, if you have a monthly sales amount category-wise. Suppose you want to read the report only for specific categories across months. In that case, you can filter only those categories using filters, and dashboard visuals will show only selected category data in visuals.

Dashboards are good, and visuals can convey the message more efficiently. But, if the dashboard can interact with the user’s queries, that kind of dashboard can make the report dynamic. Power BI is software where we can make the dashboard interactive with the users.

If you have worked with an Excel worksheet, you do not need any special introduction to filters. But in Power BI, filters are more advanced and sophisticated and have many new features.

Similarly, if you do not want to see some items in the dashboard, we can also exclude those from the view.

Filters-Power-BI

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Power BI Filters (wallstreetmojo.com)

Types of Power BI Filters

It is where Power BI is more powerful than the Excel filters because, in Power BI, we have several types of filters, which are as follows:

  • Visual-Level Filters
  • Page-Level Filters
  • Report-Level Filters
  • Drill through Filters

More importantly, if you are following an old version of Power BI, Microsoft recently launched a new filter update, which looks like this.

Power BI Filters - Version

Source: https://powerbi.microsoft.com

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

How to Add Filters in Power BI? (Top 3 Types)

You can download the workbook used in this example to practice with us from the link below.

You can download this Power BI Filters Excel Template here – Power BI Filters Excel Template

Example #1 – Visual Level Filter

It is the filter that works on an individual filter only. Therefore, the filter you apply based on that selected visual can show only that much in the visual. For example, look at the below image of two visuals.

Power BI Filters - two visuals

These two visuals are the same, but to understand how a visual level filter works.

  • On the right-hand side, you can see the “Filters” option.
Power BI Filters - Filter
  • Since no visual is selected, we cannot see any data field in the filter. Now, select the second table to see the data fields.
Visual level filter

As you can see above, we can see the data fields of the selected visual. We have three fields: “Amount,” “Card Type,” and “Date – Month.”

  • Click on the dropdown list of “Date – Month” and choose only “Jan,” “Feb,” and “Mar.”
Power BI Filters - Date – Month
  • Now, look at both the visuals.
Visual data in Filter

Only Table-2 data has been filtered for selected months, and Table-1 visual data remains the same. So, when the filter can impact specific visual effects or data, that is called a “Visual Level Filter.”

Example #2 – Page Level Filter

This filter works on all the visuals which are there in the field. For example, look at the below visuals.

Power BI Filters - Page Level

These are the visuals we have created on the page named “Report Page.” By using “Page Level Filters,” we can make the impact of the filter across all the visuals in the Power BIVisuals In The Power BIIn Power Bi, there are some built-in visuals for data visualization, as well as some custom visuals. Custom visuals are user-defined and allow users to use their own creativity in terms of how they want to present data. For example, one can use lines and dots in a flashing and floating manner to display changes in data over time.read more data.

  • We usually have the “Filters” pane on the right-hand side.
Filters Pane

Note: Since no visual has been selected, we cannot see any data fields.

Now, we must decide which data field to apply to the filter. But, first, we must drag and drop the respective field to the “Filters on this page” field.

  • We want to filter the page level visuals based on “Gender,” so we will drag and drop the field to the “Filter on this page” field.
Power BI Filters - Filter on this page
  • From this filter, “Gender” now chooses only “Male.”
Power BI Filters - Gender
  • Now, look at the impact it has on visuals.
Impact of Filter

All the visuals show only “Male” gender-related data points.

  • Another thing you can do with this filter has an option called the “Require single selection” checkbox. With this, we can choose only one item at a time.
Power BI Filters - Single Selection

Example #3 – Report Level Filter Function

This filter impacts all the pages of the report we are working on.

For example, if you have 3 pages. If you choose the option of applying a filter based on “Report Level,” it will impact all the pages’ visuals.

  • You must drag and drop the required field to the “Filters on all pages.”
Filter on all page

We have selected the “Card Type” data field. If we choose any filter, it will affect all the files’ reports.

Note: We can also download the Power BI filters file from the link below. We can view the final output.

You can download this Power BI Filters Template here – Power BI Filters Template

Things to Remember here

  • The Power BI filters are more advanced than Excel worksheet filters.
  • We mainly work with three filters: Visual Level, Page Level, and Report Level Filter.
  • We must understand what kind of impact each filter would do.

This article has been a guide to Power BI Filters. Here, we discuss the top 3 types of Power BI filters and how to add them to reports, along with an example and downloadable templates. You can learn more about Power BI from the following articles: –