Report backgrounds and images in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a sales report that looks professional and easy to read. They ask you to add a background image and a company logo to the report pages.

📊 Data: You have monthly sales data by product category and region. The data includes columns for Month, Region, Category, and Sales Amount.

🎯 Deliverable: Create a Power BI report with a background image and a company logo on each page. The report should show total sales by category and region.

Sample Data

Month	Region	Category	Sales Amount
Jan	North	Electronics	12000
Jan	South	Furniture	8000
Feb	North	Electronics	15000
Feb	East	Clothing	7000
Mar	West	Furniture	9000
Mar	South	Clothing	6000
Apr	East	Electronics	11000
Apr	West	Clothing	5000

1

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

Use 'Get Data' > 'Excel' or 'CSV' to load the sample data table.

Expected Result

Sales data is loaded and visible in the Fields pane.

2

Step 2: Create a simple table visual showing total sales by Category and Region.

Add a Table visual. Drag 'Category' and 'Region' to Rows, and 'Sales Amount' to Values with aggregation SUM.

Expected Result

Table shows total sales for each Category and Region combination.

3

Step 3: Add a background image to the report page.

In the Format pane of the report page, go to 'Page background'. Click 'Add image', select a light, subtle background image file. Set 'Transparency' to 80%.

Expected Result

Report page shows the background image faintly behind visuals.

4

Step 4: Insert the company logo image on the report page.

Use 'Insert' > 'Image'. Select the company logo file. Resize and place it at the top-left corner of the report page.

Expected Result

Company logo appears clearly on the report page without covering data.

5

Step 5: Adjust visual backgrounds and text colors for readability over the background image.

Select the table visual. In Format pane, set 'Background color' to white with 90% transparency. Set text color to dark gray or black.

Expected Result

Table is easy to read with good contrast over the background image.

6

Step 6: Save and publish the report to Power BI Service for sharing.

Click 'File' > 'Save' and then 'Publish' to your workspace.

Expected Result

Report is saved and available online with background and logo visible.

Final Result

-----------------------------------------
| LOGO          Sales Report             |
|                                       |
|  Category   | Region | Total Sales     |
|---------------------------------------|
| Electronics | North  | 27000          |
| Electronics | East   | 11000          |
| Furniture   | South  | 8000           |
| Furniture   | West   | 9000           |
| Clothing    | East   | 7000           |
| Clothing    | South  | 6000           |
| Clothing    | West   | 5000           |
|                                       |
| [Background image faintly visible]    |
-----------------------------------------

✓Electronics is the top-selling category overall.

✓North region has the highest sales in Electronics.

✓Furniture sales are strong in South and West regions.

✓Clothing sales are spread across East, South, and West.

Bonus Challenge

Add a slicer to filter the report by Month and ensure the background and logo remain visible and clear.

Show Hint

Use the Slicer visual with the 'Month' field. Adjust the slicer background and font colors for good contrast over the page background.