Assistance with Table Pagination Across Multiple Columns in Power BI Print Layout

[Aartibhilare]

Hi team

I have created a report with two columns on the page, and I'm trying to print a table that spans across both columns. The issue I'm facing is that when I print the table, it only fills the first column on the page, leaving the second column (and the remainder of the page) empty. I would like the table to print in the following order:

1. The first part of the table should print in the first column.
2. The second part of the table should continue in the second column.
3. If the table is large enough, it should continue onto the next page in the same two-column layout.

Currently, this is not happening, and the table only fills the first column, leaving the second column and subsequent pages blank.

Could you please provide guidance on how I can set up this type of table pagination across multiple columns?

i have created two columns like below

data getting print like this on first half only

but I want  like below

[v-tsaipranay]

Hi @Aartibhilare 
Thanks for reaching out to the Microsoft fabric community forum.

One possible solution to achieve your desired layout is to use Power BI Paginated Reports within Power BI Service. This approach will allow you to control the pagination and column layout.

Following are the steps to solve the issue:

• Navigate to OneLake in Power BI Service and select the semantic model you wish to use for your paginated report.
• Choose the data you want to include in your paginated report from data pane.

• Once the data is selected, you can preview the report’s page layout.

• Before saving the report, go to Page Settings and modify the page width. This will allow the table to span across both columns, ensuring the content fills the entire page.

• This approach should help you achieve the desired printing layout across multiple columns.

• You can download the RDL file by clicking on "Download Report," which will automatically open it in Report Builder.

Here, you can go and click on print layout and check whether it is working or not?

If you are still facing the issue, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you.

[Aartibhilare]

Hi @v-tsaipranay 

can't we do this in power Bi report Builder?

[v-tsaipranay · Accepted solution]

Hi @Aartibhilare ,

Thank for the reply, regarding your query confirmation.

Yes, we can do that in Power Bi report builder.

The previous solution which I provided is the easiest way to solve your query, but still if you need a solution in Power Bi report builder then following are the steps to achieve your query:

• Open Power BI Report Builder and create or open a report. Set the page size to A4 (11.69 inches wide by 8.27 inches high) in landscape mode under Report > Report Properties. Then, go to the Columns tab and set the number of columns to 2, adjusting the spacing as needed.
• Drag a Table control from the toolbox onto the report body. Resize the table to span both columns within the margins and populate it with your data, ensuring it can grow vertically.
• Select the table and set the CanGrow property to True in the Properties pane. Set the “KeepTogether” property to False to allow the table to break across columns. Ensure row height is variable for smooth flow.
• Use the Preview feature to check that the table fills both columns correctly and flows onto the next page if necessary. When satisfied, go to File > Print and ensure printer settings match the report layout.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you.

[Aartibhilare]

Hi @govind_021 any thoughts? i want it like last image

[Aartibhilare]

Hi @Bibiano_Geraldo and @Jai-Rathinavel 

any can you guys please look into this