Power BI Slicers and Filters in Reports
Slicers and filters are the tools that make Power BI reports interactive. Instead of building a separate report for each region, each year, or each product, you build one report and let the viewer choose what to see. This flexibility is one of the biggest advantages Power BI has over static spreadsheet reports.
The Difference Between Slicers and Filters
Both slicers and filters narrow down the data that visuals display. The difference is visibility and control.
A slicer sits on the canvas as a visual element — viewers see it, click on it, and use it to change what the report shows. Slicers are designed for report viewers to operate themselves without any training.
A filter lives in the Filters pane on the right side of the screen. Report builders set filters during design time. Some filters are hidden from viewers entirely — used to enforce data restrictions without showing a slicer on the canvas.
Adding a Slicer to Your Report
Click on an empty area of the canvas. In the Visualizations pane, click the Slicer icon (looks like a funnel with a list). A blank slicer placeholder appears. Drag a field from the Fields pane into the Field well of the slicer.
For example, drag "Year" from your Date table into the slicer. A list or dropdown appears showing all years in your data. Click a year — all visuals on the page instantly filter to show only that year's data.
Slicer Display Styles
Power BI slicers can appear in different formats depending on the data type and your formatting choices:
List Slicer
Shows all values as a vertical list with checkboxes. Viewers click one value or multiple values. This is the default style for text fields like Region, Category, or Salesperson.
Dropdown Slicer
Shows a collapsed dropdown that expands when clicked. Use this when the slicer has many values and you want to save canvas space. Format the slicer and change Style to "Dropdown" to enable this.
Tile Slicer
Displays values as clickable rectangular buttons. This style works well for small sets of values like "Q1 Q2 Q3 Q4" or "Online / Offline." It is visually appealing and easy to tap on mobile devices.
Date Range Slicer
Appears automatically when you add a date or date/time field to a slicer. Shows two date input boxes — a start date and an end date — and a slider for adjusting the range. Viewers can select any date range to filter the report.
Numeric Range Slicer
Appears when you add a numeric field to a slicer. Shows a slider that viewers drag to filter data above, below, or between specific values. For example, a Price range slicer lets viewers see only products priced between ₹500 and ₹2,000.
Single Select vs Multi-Select on Slicers
By default, slicers allow multiple selections — viewers can pick more than one value by holding Ctrl and clicking. You can configure a slicer to only allow one selection at a time. In the Format pane for the slicer, find Slicer Settings and toggle "Single Select" to On. This is useful when the data should only show one region, one year, or one department at a time.
Slicer Interactions — Controlling What Gets Filtered
When you click a slicer value, it filters all visuals on the page by default. Sometimes you want a slicer to affect only some visuals and not others.
Select the slicer. Go to the Format tab in the ribbon and click Edit Interactions. Arrows and filter icons appear on each visual on the page. Click the filter icon (to apply filtering) or the no-interaction icon (to exclude a visual from this slicer's effect) for each visual. Click any other element to exit Edit Interactions mode.
This lets you have one slicer that filters most charts but leaves a specific "total company" chart unaffected — showing the full picture alongside the filtered view.
Sync Slicers Across Pages
If your report has multiple pages and you want the same slicer selection to apply everywhere, use Sync Slicers. Go to the View tab in the ribbon and click Sync Slicers. A panel opens showing all the pages in your report. Select which pages should share the slicer's selection.
For example, a "Year" slicer on Page 1 that is synced to Page 2 and Page 3 means that selecting "2024" on Page 1 automatically applies the same filter when a viewer navigates to Page 2 or Page 3 — no need to set the slicer again on each page.
The Filters Pane
The Filters pane is visible on the right side of the report canvas. It has three sections:
Filters on This Visual
Select a visual first. Drag any field into this section to filter only that specific visual. For example, add a Product Category filter here set to "Electronics" — only this visual shows electronics data while all other visuals on the page remain unaffected.
Filters on This Page
Filters added here apply to every visual on the current page. The effect is similar to a slicer but the filter is invisible to viewers — they cannot see or change it. Use page-level filters to enforce data restrictions during report design.
Filters on All Pages
Filters added here apply to every visual on every page of the report. Use this for restrictions that should always apply — for example, filtering out test transactions or excluding internal employee orders from all calculations.
Top N Filtering
Top N filtering is a powerful option available in the Filters pane. Instead of selecting specific values, you tell Power BI to show only the top or bottom N items based on a measure.
For example, apply a Top N filter to a bar chart showing sales by salesperson. Set it to show the Top 10 by Total Revenue. The chart automatically shows only the ten highest-performing salespeople, and this updates dynamically if a page-level year filter changes.
To apply it, drag a field into the visual-level filter area, change the filter type from "Basic Filtering" to "Top N," specify the number and the measure to rank by, then click Apply Filter.
Clearing Filters
Viewers can clear a slicer selection by clicking the eraser icon that appears in the top right corner of the slicer when hovering over it. Report builders can clear a filter in the Filters pane by clicking the eraser icon next to that filter.