Page layout and canvas settings in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data represents the page layout and canvas settings for a Power BI report page, including page size, canvas dimensions, view mode, and background color.

Cell	Value
A1	Page Size
B1	16:9
A2	Canvas Width (px)
B2	1280
A3	Canvas Height (px)
B3	720
A4	Page View
B4	Fit to Page
A5	Page Background Color
B5	#FFFFFF

Formula Trace

Canvas Area = Canvas Width (px) * Canvas Height (px)

Step 1: Canvas Width (px) * Canvas Height (px)

Step 2: 1280 * 720

Cell Reference Map

    A               B
1 | Page Size        | 16:9       |
2 | Canvas Width (px)| 1280       |
3 | Canvas Height(px)| 720        |
4 | Page View        | Fit to Page|
5 | Page Background Color | #FFFFFF|

Cells B2 and B3 provide the canvas width and height values used in the formula to calculate the canvas area.

Result

    A           B
1 | Canvas Area | 921600    |

The calculated canvas area is displayed in cell B1 as 921600 pixels, representing the total pixel area of the report page canvas.

Sheet Trace Quiz - 3 Questions

What does the formula 'Canvas Width (px) * Canvas Height (px)' calculate?

A The aspect ratio of the page

B The total pixel area of the report canvas

C The background color code

D The page view mode

Key Result

Multiply canvas width by canvas height to get total canvas pixel area.

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