Report design best practices in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear and easy-to-understand sales performance report for the last quarter to share with the sales team.

📊 Data: You have sales data including Date, Region, Product Category, Sales Amount, and Units Sold for the last quarter.

🎯 Deliverable: Create a Power BI report that follows best design practices to show sales trends, top regions, and product category performance.

Sample Data

Date	Region	Product Category	Sales Amount	Units Sold
2024-01-05	North	Electronics	1200	5
2024-01-15	South	Clothing	800	10
2024-02-10	East	Electronics	1500	7
2024-02-20	West	Home	700	3
2024-03-05	North	Clothing	900	8
2024-03-15	South	Home	600	4
2024-03-25	East	Clothing	1100	9
2024-03-30	West	Electronics	1300	6

1

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

Use 'Get Data' > 'Excel/CSV' or paste data directly.

Expected Result

Sales data table loaded with columns: Date, Region, Product Category, Sales Amount, Units Sold.

2

Step 2: Create a Date table for time intelligence and relate it to the sales data on the Date column.

Use DAX: Date = CALENDAR(MIN(Sales[Date]), MAX(Sales[Date]))

Expected Result

Date table created and linked to Sales data for filtering by date.

3

Step 3: Create a measure for Total Sales Amount.

Total Sales = SUM(Sales[Sales Amount])

Expected Result

Measure 'Total Sales' calculates total sales correctly.

4

Step 4: Create a line chart showing Total Sales by Month.

Axis = Date[Month], Values = Total Sales

Expected Result

Line chart displays sales trend over the last quarter.

5

Step 5: Create a bar chart showing Total Sales by Region.

Axis = Sales[Region], Values = Total Sales

Expected Result

Bar chart shows sales comparison across regions.

6

Step 6: Create a pie chart showing sales distribution by Product Category.

Legend = Sales[Product Category], Values = Total Sales

Expected Result

Pie chart clearly shows sales share by product category.

7

Step 7: Apply consistent color themes and use high contrast colors for readability.

Use Power BI theme settings and select accessible color palette.

Expected Result

Report colors are consistent and easy to read.

8

Step 8: Add clear titles and labels to all visuals.

Set visual titles like 'Monthly Sales Trend', 'Sales by Region', 'Sales by Product Category'.

Expected Result

Each visual has a descriptive title and axis labels.

9

Step 9: Arrange visuals logically with enough spacing and alignment.

Place line chart on top, bar chart below left, pie chart below right.

Expected Result

Report layout is clean, balanced, and easy to scan.

10

Step 10: Add slicers for Region and Product Category to enable filtering.

Add slicers using Sales[Region] and Sales[Product Category].

Expected Result

Users can filter report by region and product category interactively.

Final Result

---------------------------------------------
| Monthly Sales Trend (Line Chart)           |
|  Jan  Feb  Mar                            * |
| 2000 2200 3900  *                         |
|                                           |
| Sales by Region (Bar Chart)                |
| North  |█████████ 2100                    |
| South  |█████ 1400                       |
| East   |██████████ 2600                   |
| West   |██████ 2000                      |
|                                           |
| Sales by Product Category (Pie Chart)     |
| Electronics: 49%                           |
| Clothing: 35%                             |
| Home: 16%                                 |
---------------------------------------------

Bonus Challenge

Add a tooltip page that shows detailed sales info when hovering over any visual.

Show Hint

Create a new report page, design detailed info, then set it as a tooltip in visual settings.