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

  1. User opens the report
  2. User selects a value in a slicer
  3. Filter is applied to visuals on the page
  4. Is the slicer synced to other pages? Yes: Same filter applies there too. No: Other pages stay unfiltered.
  5. 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 date

Example

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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic