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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Community,
maybe this is an easy question for a paginated report pro:
is it possible in paginated reports to show subgroups below groups?
status quo:
desired outcome:
Thank you!
Solved! Go to Solution.
Thank you @Swapnilmandloi , you idea is so great
Hi, @Powerwoman
Based on the information you described, I used the following sample data:
Set the format of the matrix in Report builder to the following style:
This way, you can get the style you expect:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @Swapnilmandloi , you idea is so great
Hi, @Powerwoman
Based on the information you described, I used the following sample data:
Set the format of the matrix in Report builder to the following style:
This way, you can get the style you expect:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To show subgroups below groups in a Power BI paginated report, you can follow these steps to create a stepped layout:
Create a Table Report:
Add a Parent Group:
Create the Stepped Layout:
Add Subgroups:
Adjust Formatting:
For more detailed instructions and examples, you can refer to the Power BI documentation on grouping and creating stepped reports. This approach helps in organizing your data in a hierarchical manner, making your report easier to read and navigate.
User | Count |
---|---|
6 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
2 |