Filters in Microsoft Power BI help refine data in reports by displaying only the information that meets specific conditions. They allow users to focus on relevant data subsets, making visualizations clearer and analysis more effective. Filters can be applied at the visual, page, or report level to control how data appears across a report.
Types of Power BI Filters
Visual-level Filters: Apply only to a specific visual. They allow you to control the data shown in that particular chart or table without affecting others.
Page-level Filters: Apply to all visuals on a single report page. Any filter applied here updates every visual on that page, ensuring consistent analysis.
Report-level Filters: Apply across all pages in the report. These filters maintain uniform data conditions throughout the entire report.
Drill-through Filters: Allow navigation to another page with filtered context. They help in analyzing detailed data related to a selected data point.
1. Basic Filtering
Basic filtering is the simplest and most intuitive filter mode. It provides a scrollable and searchable list of values for a specific field in our data. We can quickly search for a value and select it or use checkboxes to select multiple values.
This mode is ideal for situations where we simply want to focus on one or more data points without needing to apply complex conditions. For example, we can filter by specific countries or product categories with ease.
2. Advance Filtering
Advanced filtering gives us greater control over how data is filtered by allowing us to define more specific criteria. Instead of just selecting from a list, we can apply rules such as greater than, less than, between a range of values or even exclude certain values.
This mode is useful when we need to filter data based on numerical ranges or specific conditions. For example, we might want to exclude certain countries from the report or filter products with sales above a specific threshold.
3. Top-N Filtering
Top-N filtering is used when we want to focus on the highest or lowest N values in a dataset. This filter type allows us to quickly identify top performers or outliers. We can specify how many top or bottom items we want to display such as the top 5 countries by sales or the bottom 3 products by revenue.
Top-N filters are useful in identifying trends or analyzing the extremes within our data. For example, we might filter for the top 10 products in terms of sales or the lowest 5 regions in terms of performance.
How to add Power BI Filter to a Visual?
Step 1: Select the Visual
Step 2: Drag and Drop Fields
Step 3: Apply the Filter
How to add a Power BI Filter to a Page
Step 1: Create Multiple Visuals
Step 2: Use Visual-Level Filters
Step 3: Apply Page-Level Filters
Step 4: Select Filter Values
How to add Power BI Filter to a Report
Step 1: Create a Visual
Step 2: Populate the Visual
Step 3: Duplicate the Page
Step 4: Apply the Report-Level Filter
Step 5: Applying selected filter values across the entire report
Step 6: View the Filtered Report
Top comments (0)