Launch Deal · 50% off 1st month ·

3.4 — Configure Report Pages, Paginated Reports and Visual Calculations

PL-300 Domain 3 · Skill 3.4

What You Need to Know

Configure the report page

Format page (click an empty part of the canvas) controls:

Setting Options
Page information Page name; Allow use as tooltip (lesson 3.5); drillthrough settings
Canvas settings Type: 16:9 (default), 4:3, Letter, Tooltip, Custom (width and height in pixels); vertical alignment
Canvas background Color, image, transparency
Wallpaper The area outside the canvas
Filter pane Formatting of the pane on this page
  • Right-click a page tab to Hide it. Hidden pages still work as drillthrough and tooltip targets, and readers reach them through buttons.
  • View > Page view options: Fit to page, Fit to width, Actual size.
  • Set the canvas to a taller custom size for a page readers should scroll.

When to use a paginated report

Need Power BI report Paginated report
Interactive exploration, cross-filtering Yes Limited (parameters, drill-through links)
Pixel-perfect, printable layout (invoices, statements, regulatory forms) No Yes
A table that spans many pages and prints every row No (visuals scroll) Yes
Export to PDF, Word, Excel, CSV, XML with exact layout Basic Yes
Authoring tool Power BI Desktop Power BI Report Builder (.rdl), or create one in the service
  • Paginated reports can use a Power BI semantic model, SQL, Azure SQL, Dataverse and other sources, and they support parameters.
  • They can be published to a Pro workspace (Pro license) as well as Premium/Fabric capacities.
  • A paginated report visual embeds one inside a Power BI report.
  • From a table or matrix in the service, Create paginated report starts one from the visual's fields.

Visual calculations

A visual calculation is DAX that runs on the visual's own result matrix, not on the model. Select a visual and choose New calculation.

Running total = RUNNINGSUM([Sales])
Moving avg 3  = MOVINGAVERAGE([Sales], 3)
vs previous   = [Sales] - PREVIOUS([Sales])
% of parent   = DIVIDE([Sales], COLLAPSE([Sales], ROWS))
  • Functions designed for them include RUNNINGSUM, MOVINGAVERAGE, PREVIOUS, NEXT, FIRST, LAST, COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL and ROWS/COLUMNS axes. They can only reference fields that are in the visual.
  • They're stored with the visual, not in the model, so they can't be reused by other visuals or reports.
  • They're often simpler and faster than the equivalent model measure, which would need window functions or CALCULATE with ALLSELECTED.
  • You can hide fields from the visual and still use them in a visual calculation (for example, show only the running total).

Key Concept: Interactive analysis belongs in a Power BI report; pixel-perfect, printable, multi-page output belongs in a paginated report. Visual calculations are quick, visual-scoped DAX for running totals, moving averages and comparisons to previous or parent rows.

Exam Traps

  • Building an invoice that must print every line on separate pages as a regular Power BI report
  • Expecting a visual calculation to be reused in another visual (use a model measure)
  • Referencing a model column that isn't in the visual inside a visual calculation
  • Deleting a page used only as a drillthrough target instead of hiding it
  • Using the Letter canvas when the requirement is a tooltip page (use the Tooltip canvas type)

Check your understanding

Practice Scenario

🔒 This practice scenario is part of Skillmarked Pro

The lessons stay free. Pro unlocks the other 22 PL-300 practice scenarios and the 50-question timed mock exam, plus everything for every other exam.

See plans

Launch Deal: first month €9.95, then €19.90/month. Enter code LAUNCH50 at checkout. Ends 1 December.

Cancel anytime. Or €199 a year, which saves 17%.

Not sure yet? Try 10 free mock exam questions.

Already Pro? Log in.