Report Filters
Filters control exactly what slice of data each visual, page, or report shows, and Power BI applies them at several levels at once.
Filter Levels
- Visual-level filters - apply to a single visual only.
- Page-level filters - apply to every visual on the current report page.
- Report-level filters - apply to every page in the entire report.
- Drillthrough filters - automatically applied when a user drills through from a summary page to a detail page.
Filter Types
- Basic filtering - checkbox-style selection of specific values.
- Advanced filtering - condition-based rules such as "greater than" or "contains".
- Top N filtering - shows only the highest or lowest N items by a chosen measure.
- Relative date filtering - dynamic ranges such as "last 30 days".
Filters vs Slicers
The Filters pane works behind the scenes and is not always visible to report viewers, while slicers are on-canvas visuals that let viewers change the filter themselves.
Filters stack - a value must pass the visual, page, and report level filters simultaneously to appear, so it's easy to accidentally filter a visual down to nothing if the levels conflict.