Slicers (list, dropdown, between) in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Slicer Types in Power BI

Which slicer type in Power BI allows users to select a range of numeric values by dragging handles on a slider?

A Dropdown slicer

B Between slicer

C List slicer

D Date slicer

💡 Hint

Think about which slicer lets you pick a start and end value on a continuous scale.

The 'Between' slicer lets users select a numeric range by dragging slider handles, which is ideal for filtering continuous values.

❓ visualization

intermediate

Choosing the Best Slicer for Category Selection

You have a product category field with 50 unique values. Which slicer type is best to allow users to quickly find and select categories without scrolling through a long list?

A List slicer with multi-select enabled

B List slicer with single select

C Between slicer

D Dropdown slicer with search enabled

💡 Hint

Consider which slicer type supports searching within many items.

The dropdown slicer with search lets users type to find categories quickly, which is better than scrolling a long list.

❓ dax_lod_result

advanced

DAX Measure Behavior with Slicer Filtering

Given the following DAX measure:

Total Sales Selected = CALCULATE(SUM(Sales[Amount]), ALLSELECTED(Product[Category]))

If a list slicer on Product[Category] has 'Bikes' and 'Accessories' selected, what will this measure return?

A Sum of Sales Amount only for 'Bikes' and 'Accessories' categories

B Sum of Sales Amount for all categories ignoring slicer selection

C Sum of Sales Amount for categories not selected in the slicer

D Sum of Sales Amount for all categories except 'Bikes' and 'Accessories'

💡 Hint

Recall that ALLSELECTED respects slicer selections but removes other filters.

ALLSELECTED keeps the slicer filter context, so the measure sums sales only for the selected categories 'Bikes' and 'Accessories'.

🎯 Scenario

advanced

Designing a Dashboard with Multiple Slicer Types

You are building a sales dashboard. You want users to filter by:

• Product Category (many values)
• Order Date (range selection)
• Region (few values)

Which combination of slicer types is best to optimize user experience?

A Dropdown slicer for Product Category, Between slicer for Order Date, List slicer for Region

B List slicer for Product Category, Dropdown slicer for Order Date, Between slicer for Region

C List slicer for Product Category, Between slicer for Order Date, Dropdown slicer for Region

D Between slicer for Product Category, List slicer for Order Date, Dropdown slicer for Region

💡 Hint

Think about which slicer types fit best for many values, date ranges, and few values.

List slicer works well for many categories to see multiple selections; Between slicer is ideal for date ranges; Dropdown slicer is good for few region values to save space.

🔧 Formula Fix

expert

Troubleshooting Slicer Filtering Issue

A report uses a dropdown slicer on 'Customer Segment'. Users report that selecting a segment does not filter the sales chart as expected. Which of the following is the MOST likely cause?

A The relationship between Customer Segment and Sales tables is inactive or missing

B The slicer visual is filtered to show only one segment, so selection has no effect

C The slicer is set to 'Between' mode which does not support text fields

D The slicer is set to single select mode, but the measure uses ALLSELECTED which ignores single selections

💡 Hint

Check data model relationships when slicers do not filter visuals.

If the relationship between Customer Segment and Sales tables is inactive or missing, slicer selections won't filter the sales chart.