Slicers & Filters
Power BI · Data Visualization
Theory
Slicers and filters both limit the data a visual shows. A slicer is a visual on the canvas that report users click, such as a list, dropdown, date range or tile slicer of Region. The Filters pane holds filters at three levels: visual-level (one visual), page-level (all visuals on the page) and report-level (all pages). Filters can be basic (pick values), advanced (conditions such as 'contains') or Top N.
When a user selects North in a Region slicer, every visual on that page is filtered to North: the Total Sales card shows ₹3,200 and an Orders card shows 3. Slicers can be synced across pages with the Sync slicers pane, and you can lock or hide filters in the Filters pane so readers cannot change them. Selecting a bar in a chart also cross-filters other visuals, which acts like a temporary slicer.
Why we use it
Readers want to answer their own questions: my region, this quarter, one product line. Slicers and filters let one report serve many audiences without building separate copies.
When to use it
Use slicers for the few choices users change often, such as date, region and category. Use the Filters pane for less common or fixed filters. For data security per user, use row-level security instead; filters are not a security feature.
How it works
- User opens the report
- User selects a value in a slicer
- Filter is applied to visuals on the page
- Is the slicer synced to other pages? Yes: Same filter applies there too. No: Other pages stay unfiltered.
- Visuals show only the selected data
Syntax
Slicer: Visualizations → Slicer → drag a column
Filters pane: Filters on this visual | on this page | on all pages
View → Sync slicers (share a slicer across pages)
Filter types: Basic | Advanced | Top N | Relative dateExample
1. Add a Slicer with Sales[Region], style: Tile.
2. Add Card visuals for [Total Sales] and [Orders].
3. User clicks North → cards show ₹3,200 and 3.
4. View → Sync slicers → tick the Details page so North stays selected there.
5. Filters pane: add a page filter 'Date'[Year] = 2024 and lock it.Key points
- Slicers sit on the canvas; filters live in the Filters pane
- Filters work at visual, page and report level
- Sync slicers keeps a selection across pages
- Lock or hide filters you do not want readers to change
- Filters are not security; use RLS to restrict data