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

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.

Practice

1.

What is the main purpose of a slicer in Power BI?

easy

A. To import data from external sources

B. To create calculated columns

C. To write DAX formulas

D. To filter report data visually and interactively

Solution

1. Step 1: Understand slicer functionality

   Slicers are visual tools that let users filter data on reports easily by selecting values.

2. Step 2: Compare options to slicer purpose

   Only To filter report data visually and interactively describes filtering data visually and interactively, which matches slicer use.

3. Final Answer:

   To filter report data visually and interactively -> Option D

4. Quick Check:

   Slicer = Visual filter [OK]

Hint: Slicers filter data visually, not for calculations [OK]

Common Mistakes:

• Confusing slicers with data import tools
• Thinking slicers create calculations
• Assuming slicers write DAX formulas

2.

Which slicer type should you use to let users select a range of dates?

easy

A. Between slicer

B. List slicer

C. Dropdown slicer

D. Checkbox slicer

Solution

1. Step 1: Identify slicer types for date ranges

   Between slicers allow users to pick a start and end value, ideal for date or numeric ranges.

2. Step 2: Eliminate other slicer types

   List and dropdown slicers select single or multiple discrete values, not ranges. Checkbox slicer is not a standard type.

3. Final Answer:

   Between slicer -> Option A

4. Quick Check:

   Date range = Between slicer [OK]

Hint: Use between slicer for numeric or date ranges [OK]

Common Mistakes:

• Choosing list or dropdown for ranges
• Confusing checkbox slicer with dropdown
• Not knowing between slicer exists

3.

Given a dropdown slicer on a "Category" column with values: "A", "B", "C", what happens if the user selects "B"?

medium

A. The report filters to show rows where Category is blank

B. The report shows all rows except those where Category = "B"

C. The report filters to show only rows where Category = "B"

D. The report shows an error because dropdown slicers can't filter text

Solution

1. Step 1: Understand dropdown slicer behavior

   Dropdown slicers filter the report to show only the selected value(s) from the column.

2. Step 2: Apply selection "B" to filter

   Selecting "B" filters the data to rows where Category equals "B" only.

3. Final Answer:

   The report filters to show only rows where Category = "B" -> Option C

4. Quick Check:

   Dropdown slicer selection = Filtered data [OK]

Hint: Dropdown slicer shows only selected value's data [OK]

Common Mistakes:

• Thinking it excludes selected value
• Assuming it filters blanks
• Believing dropdown slicers can't filter text

4.

You created a between slicer on a numeric "Sales" column but it shows no slider or range. What is the likely problem?

medium

A. Between slicers only work on date columns

B. The "Sales" column is stored as text, not numeric

C. The report page is filtered to zero rows

D. The slicer type is set to dropdown instead of between

Solution

1. Step 1: Check data type for between slicer

   Between slicers require numeric or date data types to show a range slider.

2. Step 2: Identify issue with "Sales" column

   If "Sales" is text, the slicer cannot create a numeric range slider, causing no slider to appear.

3. Final Answer:

   The "Sales" column is stored as text, not numeric -> Option B

4. Quick Check:

   Between slicer needs numeric/date type [OK]

Hint: Check column data type if between slicer shows no slider [OK]

Common Mistakes:

• Assuming between slicers only work on dates
• Not verifying slicer type setting
• Ignoring data type mismatch

5.

You want users to select multiple product categories but keep the slicer compact in the report. Which slicer type and setting should you choose?

hard

A. Dropdown slicer with multi-select enabled and single select off

B. Between slicer on the category column

C. List slicer with multi-select enabled and single select off

D. List slicer with single select enabled

Solution

1. Step 1: Understand slicer types for multi-select and compactness

   Dropdown slicers take less space than list slicers and support multi-select when single select is off.

2. Step 2: Evaluate options for multi-select and compactness

   List slicers with multi-select are larger; between slicers don't apply to categories; single select disables multi-select.

3. Final Answer:

   Dropdown slicer with multi-select enabled and single select off -> Option A

4. Quick Check:

   Compact multi-select = Dropdown slicer [OK]

Hint: Use dropdown slicer with multi-select enabled and single select off for compact multiple picks [OK]

Common Mistakes:

• Choosing list slicer for compactness
• Using between slicer on text categories
• Enabling single select disables multi-select