Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
bchappidi
Frequent Visitor

Creating Hierarchy in the Same Column in Paginated Report

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:

**************************

 

Capture123.PNG

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

vyiruanmsft_0-1721878477972.png

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"

vyiruanmsft_1-1721893082235.png

4. Change the text display position for every hierarchy

vyiruanmsft_2-1721893268044.png

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

vyiruanmsft_0-1721878477972.png

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"

vyiruanmsft_1-1721893082235.png

4. Change the text display position for every hierarchy

vyiruanmsft_2-1721893268044.png

Best Regards

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.