Filters and slicers
Filtering Data in Power BI
Description: Filters are the behind-the-scenes rules that limit which data is shown in a specific visual, on a single page, or across the entire report. They are the primary tool for narrowing down massive datasets into specific, manageable insights.
Why: Reports often contain years of data for dozens of regions. Filters allow beginners to "declutter" the view, ensuring that a manager looking at 2025 performance isn't distracted by data from 2020. Understanding filter scope is key to building reports that show exactly what is intended.
The Filter Hierarchy (Scope)
In Power BI, you can apply filters at three different levels of "scope." You can manage these in the Filters Pane located next to the Visualizations pane:
| Filter Level | What it Affects |
|---|---|
| Visual-Level | Only affects the one specific chart or table you have selected. |
| Page-Level | Affects every visual on the current report page (e.g., Filtering a "Sales" page to only show 2025). |
| Report-Level | The broadest scope; affects every visual on every page of the entire report. |
Example: The Annual Review
Scenario: You have a five-page report covering a decade of business. For an annual meeting, you can apply a Report-Level Filter for the year 2025. Now, every chart on all five pages will instantly update to show only that year's data.
Interactive Slicers
Description: Slicers are "on-canvas" visual filters. Unlike the Filters Pane, which is hidden on the side, Slicers are placed directly onto the report page as buttons, dropdowns, or sliders for the user to interact with.
Why: Slicers make your reports accessible to non-technical users. Instead of navigating complex menus, a user can simply click a button for "USA" or "India" to see the charts update. This interactivity is what transforms a static report into a powerful analytical tool.
Common Slicer Styles
You can format Slicers in several ways to fit your dashboard's design:
- List/Dropdown: Best for categories like
Country,Product Category, orDepartment. - Date Range: Uses a sliding bar, perfect for selecting a specific window of time (e.g., March to June).
- Tile: Displays options as clickable buttons, which is excellent for mobile-friendly dashboards.
Example: Regional Performance Switcher
Practice Task: Add a Slicer to your report and drag the Country field into it. Switch the slicer settings to "Dropdown." A user can now toggle between India, USA, and UK, and every other visual on the page will automatically "slice" its data to match that selection.
Key Notes
- Slicer vs. Filter: Use Filters for things the user doesn't need to change (like excluding test data). Use Slicers for things the user wants to explore (like switching regions).
- Sync Slicers: If you want a Slicer on Page 1 to also control Page 2, you can use the "Sync Slicers" pane to link them together.
- Selection Controls: You can set Slicers to "Single Select" (where only one item can be picked) or "Multi-Select" (using Ctrl+Click to pick multiple items).
🏋️ Test Yourself With Exercises
Take our quiz on Filters and slicers to test your knowledge.
Browse Quizzes »