0
0
Power BIbi_tool~5 mins

Slicers (list, dropdown, between) in Power BI - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Slicers let you filter your report data easily by clicking options. They help you focus on specific parts of your data, like a certain region or date range, without changing the whole report.
When you want to let users pick one or more categories to see in charts, like product types.
When you want to save space by showing a dropdown filter instead of a long list.
When you want users to select a date range using a slider or between two dates.
When you want to quickly compare sales in different regions by clicking region names.
When you want to add interactive filters that update all visuals on the page.
Steps
Step 1: Click
- Visualizations pane > Slicer icon
A blank slicer visual appears on the report canvas
Step 2: Drag
- Field from Fields pane to the slicer visual
The slicer shows all unique values from that field as filter options
Step 3: Select
- Slicer visual > Format pane > Slicer header > turn on
A header appears on the slicer with filter controls
Step 4: Click
- Slicer visual > Format pane > Selection controls
Options to allow single or multiple selections appear
Step 5: Change
- Slicer visual > Format pane > General > Orientation
Slicer changes between vertical list or horizontal layout
Step 6: Click
- Slicer visual > Dropdown icon at top right
Slicer switches between list and dropdown mode
Step 7: For date fields, select
- Slicer visual > Format pane > Slicer settings > Slicer type > Between
Slicer shows two date pickers to select a date range
Before vs After
Before
Report page shows all sales data with no filters applied
After
Report page shows sales data only for selected regions or date range chosen in slicer
Settings Reference
Selection controls
📍 Format pane > Selection controls
Controls how many items users can select in the slicer
Default: Multi-select with CTRL
Slicer type
📍 Format pane > Slicer settings
Changes slicer display style and interaction
Default: List
Orientation
📍 Format pane > General
Sets slicer layout direction
Default: Vertical
Slicer header
📍 Format pane > Slicer header
Shows or hides slicer title and clear filter button
Default: Off
Common Mistakes
Using a slicer with too many unique values in list mode
The slicer becomes very long and hard to use
Switch slicer to dropdown mode to save space and improve usability
Not enabling multi-select when users need to pick multiple items
Users can only select one item, limiting analysis
Turn on multi-select in Selection controls to allow multiple choices
Using a list slicer for date fields instead of between slicer
Users cannot easily select a date range
Use Between slicer type for date fields to enable range selection
Summary
Slicers let users filter report data interactively by selecting values.
You can choose list, dropdown, or between (date range) slicer types.
Adjust selection controls and layout to improve user experience.