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.