Use pagination to divide large reports into smaller pages for analysis and navigation. Control how report content is displayed by configuring the number of rows per page or enabling a single scrollable page. Choose the layout that best fits the report for navigation and presentation.
The following sections describe how to use pagination options, such as defining the number of rows per page and customizing the header and footer in your reports.
Create an intelligence sheet and select the Matrix visual. Assign dimensions and measures.
Add a Super Filter visual from the Visualizations pane. Assign the dimensions to use for filtering, such as Region, Year, and Business Unit, to the Category data well.
Define the rows shown on each page
Set a fixed number of rows to show per page or dynamically add page breaks based on a dimension category.
To show a fixed number of rows on each page, select the Settings icon in the bottom right corner and then specify the number of rows to show per page.
To show the entire report on a single scrollable page, select All.
Use row breaks to combine rows from a specific level of the row hierarchy such as region or product on a dedicated page. This option groups related records together on a single page, making paginated reports easier to read. In the Format ribbon, select the Page Break icon, and then select the dimension to use for row breaks.
When page breaks are defined based on row or column dimensions, the Rows per Page setting is unavailable because page boundaries are determined by the selected dimension values.
Insert break rows to create custom page breaks at specific locations in the report. Use this option to separate key sections or logical groups, regardless of the underlying hierarchy or dimension structure. To insert a row break, select the row gripper and select Insert > Add Break Row. In the Format ribbon, select the Page Break icon, and then select Break rows.
Add a report header and footer
Add a header to show the report title, reporting period, and other summary information.
1. Hover over the header section and select Edit from the More options (...) menu. Alternatively, double-click the header to edit.
Create a custom header or apply a built-in preset to quickly add a report header. In the Header & Footer ribbon, select Presets > Header and select the header template. Header elements such as company logos, titles, and summaries are pre-formatted and positioned.
Select the container with the Your Logo placeholder to upload your organization's logo. Hover over a container and use the drag handles to resize it.
Delete the default title and insert custom text. Select the Insert element icon and select Slicer to display the slicer selections in the header.
To insert a footer, select Header & Footer in the Format ribbon to enable the Header & Footer ribbon.
Select Presets > Footer and select the preset.
To display a timestamp in the footer, select the Insert element icon, select Date, and then choose the required format.
Export reports to Excel and PDF
Select the Export icon in the Matrix ribbon to create fully formatted Excel and PDF exports for distribution.
Sample screenshot of PDF export:
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
