Slicers (list, dropdown, between) in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a slicer that shows all product categories as a list.

Power BI

Slicer visualization type should be set to [1] to display all categories.

Drag options to blanks, or click blank then click option'

ABetween

BDropdown

CMatrix

DList

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Dropdown hides all options until clicked.

Choosing Between is for numeric ranges, not categories.

Setting the slicer to List shows all items in a scrollable list, making it easy to select multiple categories.

2fill in blank

medium

Complete the code to set the slicer to a dropdown style for a cleaner look.

Power BI

Set the slicer visualization type to [1] to save space on the report.

Drag options to blanks, or click blank then click option'

ADropdown

BCard

CBetween

DList

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing List shows all options and takes more space.

Between is for numeric ranges, not categories.

The Dropdown slicer hides options until clicked, saving space and keeping the report tidy.

3fill in blank

hard

Fix the error in the slicer type to allow filtering between two dates.

Power BI

Change the slicer type to [1] to enable selecting a date range.

Drag options to blanks, or click blank then click option'

ABetween

BDropdown

CList

DPie Chart

Attempts:

3 left

💡 Hint

Common Mistakes

Using List or Dropdown only allows single selections, not ranges.

Pie Chart is not a slicer type.

The Between slicer allows users to pick a start and end date, filtering data within that range.

4fill in blank

hard

Fill both blanks to create a slicer that filters sales between two dates and shows the slicer as a dropdown.

Power BI

Set slicer type to [1] and enable [2] to filter between dates.

Drag options to blanks, or click blank then click option'

ADropdown

BBetween

CList

DSingle Select

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing List with Between can take more space.

Single Select disables multi-selection.

Using Dropdown keeps the slicer compact, and Between enables filtering between two dates.

5fill in blank

hard

Fill all three blanks to configure a slicer that shows a list, allows multi-select, and filters sales between two numeric values.

Power BI

Set slicer type to [1], enable [2] for multiple selections, and set filter mode to [3] for numeric range filtering.

Drag options to blanks, or click blank then click option'

AList

BMulti-select

CBetween

DSingle Select

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Single Select limits to one choice.

Dropdown hides options, not ideal for multi-select lists.

List shows all options, Multi-select allows choosing many items, and Between filters numeric ranges.