Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Thanks!
Solved! Go to Solution.
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |