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/COLUMNSaxes. 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.
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.
Sources
- What are paginated reports in Power BI?, Microsoft Learn
- When to use paginated reports in Power BI, Microsoft Learn
- Using visual calculations, Microsoft Learn
- Change page size in a Power BI report, Microsoft Learn