Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TJohnsonOK
Helper I
Helper I

Paginated Reports Matrix showing a page break in an incorrect location

Hi--I have been fighting with a matrix in paginated reports all day.  I copied a matrix that I already had (it has the same dataset) and changed the fields to adapt to the new data.  I did have to delete some rows.  Now when displaying, the new matrix that was copied is breaking in the wrong place.  Below is the original matrix design view.

TJohnsonOK_0-1712769342254.png

This is the copied matrix design view.

TJohnsonOK_1-1712769394072.png

On the copied matrix--I did deleted a row in the Gas FY area--note the heavy underline--I don't know if that is the problem?

TJohnsonOK_2-1712769456784.png

When exporting to a PDF--the first matrix breaks appropriately.  (it does show on 2 pages, but the page breaks are correct.

 

On the 2nd matrix, the top rows break on one page.

TJohnsonOK_3-1712769547164.png
Then the rest follows on the next page--I have tried several things--checking page breaks, etc.  The heading at the top is a row that I inserted outside the grouped areas.

I have been working with pagingated reports for only a few months, so any input would be appreciated.  Thank you in advance for your help.

@paginated reports

 

 

 






2 REPLIES 2
v-zhengdxu-msft
Community Support
Community Support

Hi @TJohnsonOK 

 

Ensure that your matrix's group properties are correctly set to manage page breaks effectively. You can right-click a row group in the Grouping pane, select Group Properties, and then navigate to the Page Breaks tab. Here, you can adjust settings to add a page break between each instance of a group, at the start of a group, or at the end of a group.

For more detailed guidance, here for your reference:

Add a page break to a Power BI paginated report - Power BI | Microsoft Learn

Then the logical page breaks are ignored for report items that are constantly hidden or whose visibility is toggled by another report item. Ensure that the visibility settings of your report items are not inadvertently affecting your page breaks. More on rendering behaviors can be found here: 

Rendering behaviors in a Power BI paginated report - Power BI | Microsoft Learn

 

Best Regards

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

Thank you so much for your reply.  I have checked all the settings and they are the same as the matrix I copied.  I copied the matrix again and started updating to the information for the matrix in question.  The problem starts when I delete one of the rows from the first matrix in this area.  

TJohnsonOK_0-1712840567527.png

What I ended up doing was copying another matrix that only had one row in this area and then added another row to it.  I was able to get it to work that way--I just am not sure why it was page breaking the way it was if I tried to delete row 2 or 3 from the matrix like I did before.  I do appreciate your help.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors