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.

Ready to Master Data Science?

Join Uncodemy's Data Science Course and build real, job-ready skills with expert mentors.

Explore Course