cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.