Page layout and canvas settings in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Effect of Changing Page Size on Visuals

You have a Power BI report page with several visuals arranged neatly. You change the page size from '16:9' to 'Letter'. What is the most likely visible effect on your visuals?

A Visuals automatically resize and reposition to fit the new page size without overlap.

B The page size change only affects export settings and does not change the canvas layout.

C Visuals keep their original size and position, causing some to be cut off or overlap.

D All visuals are deleted and need to be recreated for the new page size.

💡 Hint

Think about how fixed positions behave when the canvas size changes.

Changing the page size changes the canvas dimensions but does not automatically resize or reposition visuals. This can cause visuals to be cut off or overlap if the new size is smaller or differently shaped.

❓ dax_lod_result

intermediate

DAX Measure Impact on Canvas Size

You create a DAX measure that calculates total sales and add a card visual to your report page. If you change the page canvas size from '16:9' to 'Custom' with smaller dimensions, what happens to the card visual's display of the measure?

Power BI

Total Sales = SUM(Sales[Amount])

A The card visual scales down but still shows the full total sales value clearly.

B The card visual truncates the total sales value because of limited space.

C The card visual disappears because the measure is invalid on smaller canvases.

D The card visual automatically changes font size to fit the new canvas size.

💡 Hint

Consider how visuals behave when canvas size changes but measure values remain the same.

The card visual scales with the canvas but still displays the full measure value unless manually resized. The measure itself is unaffected by canvas size.

❓ data_modeling

advanced

Optimizing Report Layout for Different Devices

You want your Power BI report page to look good on both desktop and mobile devices. Which approach best uses page layout and canvas settings to achieve this?

A Create a mobile-optimized layout using the Power BI mobile layout view, separate from the desktop layout.

B Use a single page with a fixed canvas size and rely on automatic scaling on mobile devices.

C Design the report only for desktop canvas size and let mobile users zoom and scroll manually.

D Create separate report pages with different canvas sizes and layouts for desktop and mobile, then use bookmarks to switch.

💡 Hint

Think about Power BI features designed specifically for mobile optimization.

Power BI provides a mobile layout view to create a separate optimized layout for mobile devices without affecting the desktop layout.

🎯 Scenario

advanced

Handling Visual Overflow on Small Canvas Sizes

You have a report page with many visuals. When you reduce the canvas size, some visuals overlap or get cut off. What is the best practice to handle this situation?

A Delete some visuals to reduce clutter and fit the smaller canvas size.

B Manually resize and reposition visuals to fit the smaller canvas, or create multiple pages for different views.

C Leave visuals as they are; users can scroll horizontally and vertically to see all content.

D Increase the canvas size back to original and force users to use larger screens.

💡 Hint

Think about user experience and report design flexibility.

Manually adjusting visuals or splitting content across pages ensures a clean layout without overlap or cut-off, improving user experience.

🔧 Formula Fix

expert

Diagnosing Unexpected Blank Space on Report Canvas

You notice that your Power BI report page has unexpected blank space on the right side, even though visuals do not extend that far. Which setting is most likely causing this?

A The page background color is set to white, making blank space more visible.

B Visuals have hidden borders extending beyond their visible area, creating blank space.

C The report theme includes padding that adds blank space around visuals.

D The page size is set larger than the visible canvas area, causing extra blank space.

💡 Hint

Consider how page size and canvas dimensions relate.

If the page size is larger than the visible canvas, Power BI shows blank space where no visuals are placed.

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