Page break in multi column paginated report

[Aartibhilare]

Hello team

i was creating the power bi repoert and it has 3 columns in it like below

when i did page break based at the end of each group its breaking the column not the page

here you go for result, its just breaking the page

[Aartibhilare]

Hi @v-karpurapud 

Can you please  look into this?

[v-tsaipranay]

Hi  @Aartibhilare ,

We have not yet received a response regarding our previous reply and would like to check if your issue has been resolved.

If the solution provided addressed your query, kindly mark it as "Accept Answer" and select "Yes" if it was helpful.

Should you require any further assistance, please do not hesitate to reach out.

Thank you for your continued participation in the Microsoft Fabric Community Forum.

[Aartibhilare]

Hello @v-tsaipranay 

I haven't got solution yet

its still breaking at column level where it has to break at page level.

please have a look into it .

if you want i can share the files with you 

please find the below links for the files:

https://drive.google.com/drive/folders/1K4vEPkXFsYGUIJ36ZJl2nWAwVmOyqULa?usp=drive_link

[v-tsaipranay]

Hi @Aartibhilare ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[Aartibhilare]

Hi  @v-tsaipranay 

I have added the page break after  each date.

but still at the end of each column its not getting break

[v-tsaipranay]

Hi @Aartibhilare ,

Thank you for your response regarding the issue with page breaks after each date. As you mentioned, after adding page breaks, they don't seem to work as intended.

To address this, I created a sample dataset and implemented your issue. I was able to succeed in demonstrating the problem. Please refer to the images which I  attached below for clarification.

• Click on Tablix properties and select add page after.

• Now come back to start date, right click and open row group and group properties.

• The output which I got after adding the steps look into below images as page break after each start date.

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

Thank you.

[Aartibhilare]

Hi @v-tsaipranay 

It didn't worked

I have setup all things how you suggested as below

I have created the multi column paginated report where in report properties the number of column is 3.

the solution which you suggested works in better way if columns set to 1. but for columns 3 its not working as expected.

Let me know if you still nee further  clearification on same

[Aartibhilare]

Hi @v-tsaipranay 

i created the subreport in it but its breaking just column

like as below

any thoughts on this?

[v-tsaipranay]

Hello @Aartibhilare,

We really apologies for the delay in response as I can understand from the given details that the issue is that when you apply a page break, it works fine with a single-column report but doesn't work correctly with multi-column reports. Instead of starting a new page when the group is broken, it just breaks within the existing columns, leading to formatting issues.

As from my experience below are some possible reasons for your issue:

1. In Power BI, multi-column reports arrange data horizontally. When you add a page break within a group, it should move the data to the next page. But with multiple columns, Power BI may treat the page break as a column break instead of a page break.

2. In Power BI paginated reports, Tablix controls (tables/matrices) use row and column grouping. These groupings need to be set up correctly to ensure page breaks happen at the end of a group, not at random column breaks.

Please follow the below troubleshooting steps to resolve the issue:

• First, we must review the row grouping and page break settings in the Tablix properties. Right-click on the row or column group, select Group Properties, and check the "Page break after" option under the Page Breaks tab to ensure breaks occur after each group.
• Since you mentioned that the solution works with 1 column, consider using portrait orientation (single-column layout) for reports with page breaks. If a multi-column report is necessary, ensure that the width of the report is sufficient to fit all columns across a page.
• Ensure the Tablix has the correct width settings. A report too wide may conflict with page breaks. Also, check the column settings to ensure data wraps properly and doesn't spill into the next column.
• Adjust the number of columns and spacing settings in Report Properties to prevent overlap when page breaks occur. Consider setting the report to one column and applying page breaks before switching back to multi-column format.
• Ensure the page size and margins are correct in the Report Properties to fit the content and prevent issues with page breaks. Set the height and width of the report pages for proper placement of breaks.

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

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

Thank you for your patience and understanding.

[Aartibhilare]

Hi @v-tsaipranay 

I am currently using the power bi paginated report ( reporter builder)

I just remove sub report and created one single report for everything like below

1) i break the page between the two instance of group  like below by date but its breaking only column when we have the multi column configure where as for single column its working just fine

Multi column

single column

[v-tsaipranay]

Hi @Aartibhilare,

We really apologize for the delay in response, as we have connected with our internal experts regarding the issue and as per the Microsoft document it is clear that “Page breaks are ignored on the column groups” .

Also for your reference I am sharing the document link and the image below:
Link

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

Thankyou for your patience.

[Aartibhilare]

Hi @v-tsaipranay 

thanks for your quick responde but it is a row group not column group 

i already read this document at the start of issue 

please find the below links for the files:

https://drive.google.com/drive/folders/1K4vEPkXFsYGUIJ36ZJl2nWAwVmOyqULa?usp=drive_link

[v-tsaipranay]

Hello @Aartibhilare, 

Thank you for sharing the details. Unfortunately, I am unable to access the link you provided.

Since it is a backend issue I am unable to reproduce the scenario, I suggest you to raise a support ticket so they can assist in addressing the issue, please refer below link on how to raise a contact support or support ticket.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thank you.

[Aartibhilare]

Hello @v-tsaipranay 

I don't have a premium subscription for Power BI, so I'm unable to create the ticket.

[v-tsaipranay]

Hello @Aartibhilare,

I hope you are doing well. According to the documentation, you do not need any premium subscription to raise a support ticket. Please refer to the image and link below for more details:

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket#steps-for-creating-a-suppor...

Kindly review the link provided above and follow the outlined steps accordingly.

Thankyou for your patience.

[v-tsaipranay]

Hi @Aartibhilare ,

Thank you for your question regarding the page break issue in your multi-column paginated report.

Basically, page breaks can be added to paginated reports in the following three ways.

• Adding page breaks to a data area
• Adding page breaks to rectangles
• Adding page breaks to groups of rows in a table, matrix or list.

In response to your query, please follow the steps below to resolve the issue:

• Right-click on the group in your report and select Group Properties.Under Page Breaks, check "Between each instance of a group" to ensure each group starts on a new page.
• Make sure your report layout can accommodate multiple columns. Adjust the height of the data sections so that they fit properly and do not break into a new column prematurely.
• Ensure there are no overlapping elements (like merged cells or text boxes) in your report that might be interfering with the page breaks.
• Preview your report to verify that page breaks work correctly and maintain the multi-column format.
• If you still encounter issues, you might want to adjust the page size or orientation in the report settings for a better fit.

These steps should help resolve the issue with page breaks in your report.

More details, you can refer to below document:

Add a page break to a Report Builder paginated report - Microsoft Report Builder & Power BI Report B...

Control page breaks, headings, columns, and rows in Power BI paginated reports - Power BI | Microsof...

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

Thankyou