First Power BI report - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a simple report showing total sales by product category and month to understand sales trends.

📊 Data: You have sales data with columns: Date, Product Category, Sales Amount.

🎯 Deliverable: Create a Power BI report with a table and a line chart showing total sales by product category and month.

Sample Data

Date	Product Category	Sales Amount
2024-01-15	Electronics	1200
2024-01-20	Clothing	800
2024-02-05	Electronics	1500
2024-02-10	Clothing	700
2024-03-12	Electronics	1300
2024-03-15	Clothing	900
2024-01-25	Home Goods	600
2024-02-20	Home Goods	750
2024-03-22	Home Goods	800

1

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

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the table with columns Date, Product Category, Sales Amount.

Expected Result

Sales data is loaded and visible in the Fields pane.

2

Step 2: Create a new column to extract the month and year from the Date column for grouping.

New Column formula: MonthYear = FORMAT('Table'[Date], "yyyy-MM")

Expected Result

A new column 'MonthYear' is added showing values like '2024-01', '2024-02', etc.

3

Step 3: Create a measure to calculate total sales amount.

Total Sales = SUM('Table'[Sales Amount])

Expected Result

A measure 'Total Sales' is created that sums sales amounts.

4

Step 4: Add a table visual to the report canvas showing Product Category, MonthYear, and Total Sales.

Drag 'Product Category' and 'MonthYear' to Rows, and 'Total Sales' to Values in the table visual.

Expected Result

Table shows total sales by product category and month.

5

Step 5: Add a line chart visual to show sales trends over months for each product category.

Set Axis to 'MonthYear', Legend to 'Product Category', and Values to 'Total Sales'. Sort Axis by MonthYear ascending.

Expected Result

Line chart displays sales trends by month for each product category.

6

Step 6: Format visuals for clarity: add titles, adjust colors for contrast, and enable data labels on the line chart.

Use Visualizations pane to set titles like 'Sales by Category and Month', choose distinct colors, and turn on data labels.

Expected Result

Report visuals are clear, readable, and accessible.

Final Result

Power BI Report

+-----------------------------------------+
| Sales by Category and Month              |
|-----------------------------------------|
| Product Category | Month  | Total Sales |
|------------------|--------|-------------|
| Electronics      | 2024-01| 1200        |
| Electronics      | 2024-02| 1500        |
| Electronics      | 2024-03| 1300        |
| Clothing         | 2024-01| 800         |
| Clothing         | 2024-02| 700         |
| Clothing         | 2024-03| 900         |
| Home Goods       | 2024-01| 600         |
| Home Goods       | 2024-02| 750         |
| Home Goods       | 2024-03| 800         |
+-----------------------------------------+

Line Chart: Sales Trends

Month: 2024-01 -> 2024-03
Lines: Electronics, Clothing, Home Goods
Sales values rising and falling per category over months.

✓Electronics category has the highest sales overall.

✓Sales for Electronics peaked in February 2024.

✓Clothing sales are steady but lower than Electronics.

✓Home Goods sales are the lowest but show a slight increase over the months.

Bonus Challenge

Add a slicer to the report to filter sales by Product Category interactively.

Show Hint

Use the Slicer visual, drag 'Product Category' field into it, so users can select one or multiple categories to filter the report.