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
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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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.