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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mycwidms
Advocate II
Advocate II

How to page break by group in a paginated report

Hi, is there a way to page break by Make in this example so that you actually get two tables instead of one? I tried to add page break by Make group but nothing happens. The bottom two tables - per make is just a filtered view of the matrix that has both. Any suggestions?

 

Capture.PNG

Thank you

2 REPLIES 2
mycwidms
Advocate II
Advocate II

Hi, @v-yiruan-msft 

 

Appriciate the answer. This does not seem like the proper solution to the problem nor the instructions. Page break by group does not seem to break the column groups. We need to break where the red line is and move toyota to page 2 and display honda only on page 1:

 

Capture.PNG

v-yiruan-msft
Community Support
Community Support

Hi @mycwidms ,

You can follow the steps below to achieve it, please find the details in the screenshot below...

1. Insert a table

2. Go to the Row Groups pane, and click on the down arrow beside the Make. Please select the Group Properties option. Go to Page Breaks tab, and check the option "Between each instance of a group".

  • Between each instance of a group: If you select this option, Page will break when a new group starts. For example, Queensland in Australia is a new group instance, so it will break at that point and display all records belong to Queensland on a new page.
  • Also at the start of a group: This will apply page break before Queensland
  • Also at the end of a group: This will use page break after Queensland

yingyinr_0-1656578608783.png

Best Regards

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.