Slicers (list, dropdown, between) in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants an interactive sales report where they can filter sales data by product category, region, and date range easily.

📊 Data: You have a sales dataset with columns: Date, Region, Product Category, Sales Amount.

🎯 Deliverable: Create a Power BI report with slicers: a list slicer for Product Category, a dropdown slicer for Region, and a between slicer for Date to filter the sales data dynamically.

Sample Data

Date	Region	Product Category	Sales Amount
2024-01-05	North	Electronics	1200
2024-01-10	South	Clothing	850
2024-01-15	East	Electronics	950
2024-01-20	West	Furniture	700
2024-02-05	North	Clothing	1100
2024-02-10	South	Furniture	650
2024-02-15	East	Clothing	900
2024-02-20	West	Electronics	1300
2024-03-05	North	Furniture	800
2024-03-10	South	Electronics	1400
2024-03-15	East	Furniture	750
2024-03-20	West	Clothing	900

1

Step 1: Load the sales data into Power BI Desktop by importing the table with columns Date, Region, Product Category, and Sales Amount.

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the data.

Expected Result

Sales data is loaded and visible in the Fields pane.

2

Step 2: Create a list slicer for Product Category to allow selecting one or multiple categories.

Insert a slicer visual, drag 'Product Category' field to it, and set slicer type to 'List'.

Expected Result

A vertical list slicer showing all product categories: Electronics, Clothing, Furniture.

3

Step 3: Create a dropdown slicer for Region to save space and allow single selection.

Insert another slicer visual, drag 'Region' field to it, and set slicer type to 'Dropdown'.

Expected Result

A dropdown slicer with options: North, South, East, West.

4

Step 4: Create a between slicer for Date to filter sales by a date range.

Insert a slicer visual, drag 'Date' field to it, and set slicer type to 'Between'.

Expected Result

A date range slicer allowing selection of start and end dates.

5

Step 5: Add a card visual to show total sales amount that updates based on slicer selections.

Insert a Card visual, drag 'Sales Amount' field, and set aggregation to SUM.

Expected Result

Card shows total sales amount filtered by slicers.

6

Step 6: Test the slicers by selecting different product categories, regions, and date ranges to see the total sales update accordingly.

Interact with slicers on the report page.

Expected Result

Total sales amount changes dynamically based on slicer filters.

Final Result

↓

↓

↓

North

↓

2024-01-01

✓Slicers allow quick filtering of sales data by product category, region, and date range.

✓The total sales card updates instantly to reflect the selected filters.

✓Using different slicer types improves report usability and saves space.

Bonus Challenge

Add a slicer for Sales Amount using a numeric range slider to filter sales transactions by amount.

Show Hint

Insert a slicer, drag 'Sales Amount' field, and set slicer type to 'Between' to create a numeric range filter.