Combine Multiple Matrix Visualisations from Separate Tabs into One Long Printable Page (A4) in Power

Hi everyone,

I’m trying to recreate an Excel-based report in Power BI and could use some help or design guidance.

I’ve built a Power BI .pbix file that mirrors an Excel workbook containing several grids (each grid is represented in Power BI as a Matrix visualisation).

Currently:

• Each tab/page in my Power BI report contains one Matrix visualisation.

• Each Matrix pulls from a SQL database view and uses bespoke DAX measures.

• Each tab shares a global date filter but also has individual page-level filters.

• When exporting to PDF, I end up with multiple pages (one per tab).

🧠 What I want to achieve:

I’d like to stack all these Matrix visuals vertically (one below the other) into a single continuous page — ideally:

• Presented as one long scrolling page in Power BI Desktop/Service, or

• Exported as one A4 (or multiple continuous A4 pages) in a printable format (e.g., PDF).

Essentially, I want to turn my multi-tab report into a single “summary” page that contains all 12 matrices in order — like a “long-form” or “scrolling” report layout.

🔧 What I’ve tried but wasn't good at:

• Creating a new summary page and copy-pasting all matrices onto one A4-sized page — but fitting all 12 (with filters) is not practical.

• Exploring Paginated Reports (Report Builder), but unsure how best to connect all my existing DAX and SQL-based data in one layout.

• Looking for a way to either:

  • Auto-stack multiple report pages (like a continuous print view), or

  • Programmatically merge all matrices into one large paginated layout.

❓ My questions:

1. Is there any way to combine multiple report tabs into one printable/scrollable layout in Power BI Desktop or Service?

2. Would Paginated Reports be the recommended approach here — given I already have DAX measures and SQL-based datasets in my Power BI model?

3. If yes, what’s the best way to replicate the look and feel of my existing Power BI matrices in Report Builder using the same dataset?

4. Any known techniques, community examples, or best practices for turning multi-tab matrix reports into one stacked printable summary?

🧱 Environment details:

• Power BI Desktop (October 2025)

• Data source: SQL Server Views

• Using DAX measures for custom KPIs

• Published workspace: Premium Per User

• Report structure: 12 tabs, each with one Matrix visualisation and shared slicers

🙏 Any guidance appreciated!

If someone has tackled something similar (Excel-to-Power BI long-form paginated migration), I’d really appreciate examples, best practices, or design suggestions.

Thank you!