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

Dashboard Mode - Slicers (list, dropdown, between)

Dashboard Goal

Help the sales manager explore sales data by filtering products, regions, and sales dates using slicers.

Sample Data

OrderID	Product	Region	SalesDate	SalesAmount
1001	Chair	East	2024-01-15	250
1002	Table	West	2024-02-20	450
1003	Desk	East	2024-03-05	300
1004	Chair	South	2024-01-25	200
1005	Table	North	2024-02-10	500
1006	Desk	West	2024-03-15	350
1007	Chair	North	2024-01-30	275
1008	Table	South	2024-02-25	400

Dashboard Components

• KPI Card: Total Sales Amount
  Formula: Total Sales = SUM(Sales[SalesAmount])
  Shows the sum of sales filtered by slicers.
• Bar Chart: Sales by Product
  Shows total sales amount for each product, filtered by slicers.
• Table: Sales Details
  Shows OrderID, Product, Region, SalesDate, and SalesAmount filtered by slicers.
• Slicer (List): Product
  Allows selecting one or multiple products to filter all visuals.
• Slicer (Dropdown): Region
  Allows selecting one region from a dropdown to filter all visuals.
• Slicer (Between): SalesDate
  Allows selecting a date range to filter all visuals.

Dashboard Layout

+--------------------------------------------------+
| Product Slicer (List)   | Region Slicer (Dropdown) |
|------------------------|--------------------------|
| SalesDate Slicer (Between)                       |
+--------------------------------------------------+
| Total Sales KPI Card                             |
+--------------------------------------------------+
| Bar Chart: Sales by Product                      |
+--------------------------------------------------+
| Table: Sales Details                             |
+--------------------------------------------------+

Interactivity

All slicers filter the KPI card, bar chart, and sales details table simultaneously.

• Product Slicer (List): Selecting products filters data to only those products.
• Region Slicer (Dropdown): Selecting a region filters data to that region only.
• SalesDate Slicer (Between): Selecting a date range filters data to sales within those dates.

Changing any slicer updates all visuals instantly, helping explore sales by different slices.

Self Check

Try this: Add a filter selecting Product = Chair and Region = East with SalesDate between 2024-01-01 and 2024-01-31.

Question: Which rows remain in the sales details table and what is the total sales amount shown in the KPI card?

Answer: Only OrderID 1001 remains (Product: Chair, Region: East, SalesDate: 2024-01-15, SalesAmount: 250). Total Sales KPI shows 250.

Key Result

Sales dashboard with slicers for Product (list), Region (dropdown), and SalesDate (between) filtering total sales, sales by product chart, and sales details table.