Reporting - Basic and advanced filters

In this article, we’ll look at examples of Basic and advanced filters and show how they might be used to filter results in a Power BI report. 

In most cases, a report will be filtered using Basic Filters. However, advanced filters offer greater flexibility. For example, Advanced filters can be used for:

• Down-selecting data based on a specific word or phrase
• Applying Top X and Bottom X rankings to your data
• Excluding rows where a specific data field is empty

In this video,  that might be used and sit alongside basic filters to make your reports do what you need.

Basic filters

Basic filters show a list of all the values in the field. You can search in page, visual, and report filters to find and select the value you want. For example, the filter type 'Basic filtering' is selected, and a choice of Yes or No is available:

Advanced filters

Advanced filters allow for more complexity. For example, you could search for values that 'contain' or 'don't contain', 'start with' or 'don't start with', and specific values.

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.