WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI Filters

Power BI Filters

Filters in Power BI

In Power BI, filter function is used more to read the data or report based on multiple criteria.There are many filters in power Bi and the most commonly used filter in this tool is as follows, Visual Level filters, page-level filters, report level filters, Drill through filters, applying a filter to visual level, or applying a filter to page level.

For example, if you have monthly sales amount on category-wise and if you want to read the report only for specific categories across months, 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, then that kind of dashboard can make the report dynamic. Power BI one such a software where we can make the dashboard interactive with the users.

If you have worked with an excel worksheet, then you don’t need any special introduction about filters, but in Power BI, filters are more advanced, sophisticated and have many new features in it.

Similarly, if you don’t want to see some items in the dashboard, we can exclude those as well from the view.

Power BI Filters

Types of Power BI Filters

This 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, recently, Microsoft has launched a new update for filters, and it looks like this.

Popular Course in this category
Sale
Power BI Training Certification
4.5 (521 ratings)
6 Online Courses | 29+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course

Power BI Filters - Version

Source: https://powerbi.microsoft.com

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

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

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

Example #1 – Visual Level Filter

This is the filter that works on an individual filter only. As per the filter you apply based on that selected visual can show only that much amount 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 “visual level filter” works.

  • On the right-hand side, you can see the “Filters” option.

Power BI Filters - Filter

  • Since there is no visual 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 here, i.e., “Amount,” “Card Type,” and “Date – Month.”

  • Click on the drop-down 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, then that is called “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 BI data.

  • As usual, on the right-hand side, we have “Filters Pane.”

Filters Pane

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

Now we need to decide on which data field we need to apply the filter for, and based on that, we need to drag and drop the respective field to the “Filters on this page” field.

  • Now I want to filter the page level visuals based on “Gender-wise,” so I will drag and drop the field to “Filter on this page” field.

Power BI Filters - Filter on this page

  • Now from this filter, “Gender” choose only “Male.”

Power BI Filters - Gender

  • Now, look at the impact it has on visuals.

Impact of Filter

Now all the visuals are showing only “Male” gender-related data points.

  • One more thing you can do with this filter is we have an option called “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 at the moment.

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

  • For this, you need to drag and drop the required field to the “Filters on all pages.”

Filter on all page

I have selected the “Card Type” data field, and if I choose any filter, it will affect all the reports in the file.

Note: Power BI Filters file can also be downloaded from the link below, and the final output can be viewed.

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

Things to Remember here

  • Power BI filters are more advanced than excel worksheet filters.
  • We mainly work with three kinds of filters i.e., Visual Level, Page Level, and Report Level Filter.
  • You need to understand what kind of impact each filter would do.

Recommended Articles

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

  • Add Slicers Filter in Power BI
  • Tooltip in Power BI
  • Conditional Formatting in Power BI
  • Connections in Power BI
  • Power BI Switch
4 Shares
Share
Tweet
Share
Power BI Training Certification
  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Download Power BI Filters Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Power BI Filters Excel Template

New Year Offer - Power BI Training Certification (22+ Hours of Training) View More