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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
v0v0
Advocate I
Advocate I

Page break for column groups - paginated reports in Power BI Report Builder

Hi!

I am creating a report with some year/month column groups (as below).

I would like to have a page break for every year group (not month group) in Power BI report builder.

I am able to do so with the row groups, but can't seem to do it with the column groups.

Any ideas?

 

v0v0_0-1657295133552.png

 

Thanks!

 

1 ACCEPTED SOLUTION
v-xiaoyan-msft
Community Support
Community Support

Hi @v0v0 ,

 

You can organize data into groups by rows or columns. Row groups expand vertically on a page. Column groups expand horizontally on a page. Groups can be nested, for example, group first by [Year], then by [Quarter], then by [Month]. Groups can also be adjacent, for example, group on [Territory] and independently on [ProductCategory].

 

For more information,you can see if it helps

Filter, group, and sort data in paginated reports (Report Builder) 

Groups in a Tablix Data Region: Details, Row, and Column Groups 

 

Best Regards,
Community Support Team _ Caitlyn

View solution in original post

1 REPLY 1
v-xiaoyan-msft
Community Support
Community Support

Hi @v0v0 ,

 

You can organize data into groups by rows or columns. Row groups expand vertically on a page. Column groups expand horizontally on a page. Groups can be nested, for example, group first by [Year], then by [Quarter], then by [Month]. Groups can also be adjacent, for example, group on [Territory] and independently on [ProductCategory].

 

For more information,you can see if it helps

Filter, group, and sort data in paginated reports (Report Builder) 

Groups in a Tablix Data Region: Details, Row, and Column Groups 

 

Best Regards,
Community Support Team _ Caitlyn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.