The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi Everyone,
I have a question about how we can create a hierarchy in the same column in a paginated report, as shown in the attached screenshot.
When I create row groups, the hierarchy levels are showing as different columns. Please let me know how to achieve this.
Expected design /output:
**************************
I want a hierarchy similar to the one mentioned in the link below
https://www.reporting-services.eu/index.php/2019/06/22/splitting-merging-cells-in-tablix/
Thank you!
Solved! Go to Solution.
Hi @bchappidi ,
You can refer the following links to get it:
Create a recursive hierarchy group in a paginated report - Microsoft Report Builder
Grouping pane in a Power BI paginated report - Power BI | Microsoft Learn
Add or delete a group in a data region in a paginated report - Microsoft Report Builder
And you can follow the steps below to get it:
1. Insert a table
2. Drag one field which you want it to be as a hirerachy onto the table
3. Select the table and right-click to select "Insert Row"-->"Inside group - Below"
4. Change the text display position for every hierarchy
Best Regards
Hi @bchappidi ,
You can refer the following links to get it:
Create a recursive hierarchy group in a paginated report - Microsoft Report Builder
Grouping pane in a Power BI paginated report - Power BI | Microsoft Learn
Add or delete a group in a data region in a paginated report - Microsoft Report Builder
And you can follow the steps below to get it:
1. Insert a table
2. Drag one field which you want it to be as a hirerachy onto the table
3. Select the table and right-click to select "Insert Row"-->"Inside group - Below"
4. Change the text display position for every hierarchy
Best Regards