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.
Ask the Community🤝
Want to connect with peers and hear how they are using the Fixed reports? Our customer Community is a great place to get quick, relatable advice - so jump in, ask your question, and learn from the wider customer Community.
Get deeper learning in The Academy🎓
The Academy provides structured learning paths you can follow at your own pace, along with live events where you can connect with the Kallidus team and fellow learners. Here's some relevant content to get you started:
Explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs.
If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI.
Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, or join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.