Why interactivity enables exploration in Power BI - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants a report that helps the sales team explore sales data easily to find trends and insights on their own.

📊 Data: You have monthly sales data by region, product category, and sales amount for the past year.

🎯 Deliverable: Create an interactive Power BI report with filters and visuals that let users explore sales by region, category, and month.

Sample Data

Month	Region	Category	Sales Amount
Jan	North	Electronics	12000
Jan	South	Furniture	8000
Feb	North	Electronics	15000
Feb	East	Clothing	7000
Mar	South	Electronics	11000
Mar	East	Furniture	9000
Apr	North	Clothing	6000
Apr	South	Clothing	7500
May	East	Electronics	13000
May	North	Furniture	8500
Jun	South	Electronics	14000
Jun	East	Clothing	7200

1

Step 1: Load the sales data into Power BI Desktop.

Use 'Get Data' > 'Excel/CSV' and import the sales data table.

Expected Result

Sales data table appears in Power BI with columns: Month, Region, Category, Sales Amount.

2

Step 2: Create a bar chart visual showing total sales by Region.

Visual: Bar chart; Axis = Region; Values = SUM(Sales Amount).

Expected Result

Bar chart displays total sales for each region.

3

Step 3: Add a slicer visual to filter data by Month.

Visual: Slicer; Field = Month.

Expected Result

Slicer allows selecting one or multiple months to filter all visuals.

4

Step 4: Add another slicer to filter data by Category.

Visual: Slicer; Field = Category.

Expected Result

Slicer allows selecting product categories to filter all visuals.

5

Step 5: Create a line chart showing sales trends over months for the selected filters.

Visual: Line chart; Axis = Month; Values = SUM(Sales Amount); Legend = Region.

Expected Result

Line chart shows sales trends by region over months, updating with slicer selections.

6

Step 6: Test interactivity by selecting different months and categories in slicers and observe charts update.

Use slicers to select 'Jan' and 'Feb' months and 'Electronics' category.

Expected Result

Bar and line charts update to show sales only for Electronics in Jan and Feb.

7

Step 7: Add tooltips to visuals to show exact sales amounts when hovering over bars or lines.

Enable default tooltips showing SUM(Sales Amount) on hover.

Expected Result

Hovering over chart elements shows exact sales numbers.

8

Step 8: Publish the report to Power BI Service and share with the sales team.

Use 'Publish' button in Power BI Desktop and share link with team.

Expected Result

Sales team can interact with the report online to explore sales data themselves.

Final Result

Power BI Report Dashboard

[Month Slicer]  [Category Slicer]

| Region Sales Bar Chart |
|=======================|
| North  | ██████████  |
| South  | ████████    |
| East   | ███████     |

| Sales Trend Line Chart (Months on X-axis, Sales on Y-axis) |
|-----------------------------------------------------------|
| Jan  Feb  Mar  Apr  May  Jun                              |
|  |    |    |    |    |    |                               |
|  *----*----*----*----*----*                               |
|  (Lines show sales trends by region, updating with slicers)|

✓Interactivity with slicers lets users filter data by month and category easily.

✓Charts update instantly to reflect selected filters, helping users explore trends.

✓Tooltips provide exact sales numbers on hover, improving data understanding.

✓The sales team can find insights themselves without needing new reports each time.

Bonus Challenge

Add a drill-through page that shows detailed sales transactions when a user right-clicks a region in the bar chart.

Show Hint

Create a new report page with detailed sales table and set up drill-through filter on Region field.