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.

Practice

1. What does the Page Size setting control in Power BI report layout?

easy

A. The font size of all text on the page

B. The color of the report background

C. The number of visuals on the page

D. The width and height of the report page

Solution

1. Step 1: Understand the role of Page Size

   Page Size defines the dimensions (width and height) of the report page canvas.

2. Step 2: Differentiate from other settings

   Background color and font size are controlled separately, not by Page Size.

3. Final Answer:

   The width and height of the report page -> Option D

4. Quick Check:

   Page Size = width and height [OK]

Hint: Page Size means page dimensions, not colors or fonts [OK]

Common Mistakes:

• Confusing Page Size with background color
• Thinking Page Size changes font or visuals count

2. Which of the following is the correct way to set a solid background color for a Power BI report page?

easy

A. Go to Format pane > Page Background > Color and pick a color

B. Use the Page Information pane to select Background Color

C. Right-click on the canvas and choose Set Background Color

D. Change the theme to a solid color theme

Solution

1. Step 1: Locate background color setting

   Background color is set in the Format pane under Page Background.

2. Step 2: Confirm correct method

   Go to Format pane > Page Background > Color and pick a color correctly describes going to Format > Page Background > Color to pick a color.

3. Final Answer:

   Go to Format pane > Page Background > Color and pick a color -> Option A

4. Quick Check:

   Background color set in Format > Page Background [OK]

Hint: Background color is in Format pane, not Page Information [OK]

Common Mistakes:

• Trying to set background color from Page Information
• Right-click menu does not set background color
• Changing theme affects more than just background

3. If you set the Page Size to 16:9 and the Canvas Background to a light gray color, what will you see on the report page?

medium

A. A square page with white background

B. A page with 4:3 ratio and dark background

C. A rectangular page with 16:9 ratio and a light gray background

D. A page with 16:9 ratio but no background color

Solution

1. Step 1: Understand Page Size 16:9

   Setting Page Size to 16:9 creates a rectangular canvas with width to height ratio of 16:9.

2. Step 2: Apply Canvas Background color

   Setting Canvas Background to light gray changes the page background color accordingly.

3. Final Answer:

   A rectangular page with 16:9 ratio and a light gray background -> Option C

4. Quick Check:

   Page Size + Background color = rectangular gray page [OK]

Hint: Page Size sets shape; background color fills canvas [OK]

Common Mistakes:

• Assuming default square page instead of 16:9
• Ignoring background color setting
• Confusing 16:9 with 4:3 ratio

4. You tried to set a background image on your Power BI page, but it does not appear. Which of these is the most likely cause?

medium

A. You set the image in the Visualizations pane instead of Format pane

B. The image file is too large or unsupported format

C. You forgot to enable the image by setting Transparency to 100%

D. Background images are not supported in Power BI

Solution

1. Step 1: Check image file requirements

   Power BI requires supported image formats and reasonable file size for background images.

2. Step 2: Understand transparency setting

   Transparency 100% means fully transparent (invisible), so it should be less than 100% to see image.

3. Final Answer:

   The image file is too large or unsupported format -> Option B

4. Quick Check:

   Image file size/format issues block background image [OK]

Hint: Check image size and format if background image missing [OK]

Common Mistakes:

• Setting transparency to 100% hides image
• Trying to set image in wrong pane
• Believing background images are unsupported

5. You want to create a Power BI report page that fits perfectly on a mobile screen and has a custom background image with 50% transparency. Which steps should you follow?

hard

A. Set Page Size to Mobile layout, add background image in Format pane, set Transparency to 50%

B. Set Page Size to 16:9, add background image in Visualizations pane, set Transparency to 0%

C. Set Page Size to Custom with mobile dimensions, add background image in Format pane, set Transparency to 100%

D. Set Page Size to Mobile layout, add background image in Format pane, set Transparency to 100%

Solution

1. Step 1: Choose Mobile layout for Page Size

   Power BI offers Mobile layout preset to fit mobile screen dimensions.

2. Step 2: Add background image in Format pane and set transparency

   Background images are set in Format > Page Background; transparency controls visibility, 50% shows image semi-transparent.

3. Final Answer:

   Set Page Size to Mobile layout, add background image in Format pane, set Transparency to 50% -> Option A

4. Quick Check:

   Mobile layout + background image + 50% transparency = correct setup [OK]

Hint: Mobile layout + Format pane background + 50% transparency [OK]

Common Mistakes:

• Setting transparency to 100% hides image
• Adding image in Visualizations pane instead of Format pane
• Using wrong Page Size preset