Why interactivity enables exploration in Power BI - Dashboard Impact

Dashboard Mode - Why interactivity enables exploration

Business Question

How can interactive filters help us explore sales data to find trends and insights quickly?

Sample Data

Region	Product	Month	Sales
East	Widget	Jan	100
East	Gadget	Jan	150
West	Widget	Jan	200
West	Gadget	Jan	250
East	Widget	Feb	120
East	Gadget	Feb	180
West	Widget	Feb	220
West	Gadget	Feb	270

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 1490
• Bar Chart: Sales by Region
  Formula: SUM(SalesData[Sales]) grouped by SalesData[Region]
  Result: East = 550, West = 940
• Line Chart: Sales over Months
  Formula: SUM(SalesData[Sales]) grouped by SalesData[Month]
  Result: Jan = 700, Feb = 790
• Table: Sales by Product and Month
  Shows sales numbers for each product per month
• Filter: Region Slicer
  Allows selecting East, West, or both regions

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |    Region Slicer     |
|       (KPI Card)      |    (Filter)          |
+----------------------+----------------------+
|      Bar Chart: Sales by Region           |
|                                          |
+------------------------------------------+
|      Line Chart: Sales over Months        |
+------------------------------------------+
|      Table: Sales by Product and Month    |
+------------------------------------------+

Interactivity

The Region Slicer lets you pick which region's data to see. When you select East, all visuals update to show only East region sales. If you select West, the charts and table update accordingly. Selecting both shows combined data. This lets you explore differences between regions easily.

Self Check

If you add a filter to select only the East region, which components update and what changes?

• Total Sales KPI updates to 550.
• Bar Chart shows only East region sales bar.
• Line Chart shows sales over months for East only (Jan=250, Feb=300).
• Table shows sales for East region products and months only.

Key Result

Interactive sales dashboard showing total sales, sales by region and month, with a region filter to explore data.