Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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