Page layout and canvas settings 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 professional sales report page that fits well on different screen sizes and prints correctly.

📊 Data: You have monthly sales data by product category and region.

🎯 Deliverable: Create a Power BI report page with proper page layout and canvas settings to optimize viewing and printing.

Sample Data

Month	Region	Category	Sales
Jan	North	Electronics	12000
Jan	South	Furniture	8000
Feb	North	Electronics	15000
Feb	South	Furniture	9000
Mar	North	Electronics	13000
Mar	South	Furniture	8500
Apr	North	Electronics	16000
Apr	South	Furniture	9500

1

Step 1: Open Power BI Desktop and load the sales data.

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

Expected Result

Sales data is loaded into Power BI with columns Month, Region, Category, and Sales.

2

Step 2: Create a new report page for the sales summary.

Click the '+' icon at the bottom to add a new page.

Expected Result

A blank report page is ready for layout and visuals.

3

Step 3: Set the page size to 'Letter' for printing.

In the Visualizations pane, select the Format tab > Page size > choose 'Letter'.

Expected Result

The canvas size changes to 8.5 x 11 inches suitable for printing.

4

Step 4: Set the page orientation to 'Portrait'.

In Format > Page size > Orientation, select 'Portrait'.

Expected Result

The page layout is vertical, matching typical print layout.

5

Step 5: Adjust the canvas background color to white for clarity.

In Format > Canvas settings > Background color, set to white (#FFFFFF).

Expected Result

The report page background is white, improving readability.

6

Step 6: Enable 'Lock aspect ratio' to maintain layout proportions when resizing.

In Format > Canvas settings, toggle 'Lock aspect ratio' to On.

Expected Result

Canvas resizing keeps the proportions consistent.

7

Step 7: Add a bar chart visual showing total sales by month.

Insert a bar chart: Axis = Month, Values = SUM(Sales).

Expected Result

Bar chart displays monthly sales totals clearly.

8

Step 8: Resize and position the bar chart to fit the top half of the page.

Drag the visual edges to cover the upper half of the canvas.

Expected Result

Bar chart fits well without overlapping page edges.

9

Step 9: Add a slicer for Region to filter the report.

Insert slicer visual: Field = Region.

Expected Result

User can filter sales data by region interactively.

10

Step 10: Place the slicer on the right side of the page, aligned vertically.

Drag slicer visual to right edge, align top to bottom.

Expected Result

Slicer is easy to find and does not clutter the page.

11

Step 11: Set page margins to standard values for printing.

In Format > Page size > Margins, set to 'Normal' or custom 0.5 inches.

Expected Result

Page margins ensure content is not cut off when printed.

12

Step 12: Preview the report page in 'View' mode and test resizing.

Click 'View' > 'Fit to page' and resize window to check layout.

Expected Result

Report page looks balanced and readable on different screen sizes.

Final Result

|||||||||

↓

|||||||||||||

↓

||||||||||

↓

|||||||||||||||

↓

North

✓Sales increase from January to April in the Electronics category.

✓North region generally has higher sales than South.

✓Page layout settings ensure the report prints well and is easy to read on screen.

Bonus Challenge

Add a dynamic page size setting that switches between 'Letter' and 'A4' based on user selection.

Show Hint

Use bookmarks and buttons to toggle page size settings in Power BI.