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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Powerwoman
Helper II
Helper II

Paginated reports - Nested matrix: show subgroup below group

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:

 

Powerwoman_1-1720166462884.png

 

desired outcome:

 

Powerwoman_0-1720164237394.png

Thank you!

 

 

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Thank you @Swapnilmandloi , you idea is so great

Hi, @Powerwoman 

Based on the information you described, I used the following sample data:

vjianpengmsft_0-1720493449887.png

Set the format of the matrix in Report builder to the following style:

vjianpengmsft_1-1720493485573.png

This way, you can get the style you expect:

vjianpengmsft_2-1720493525538.png

 

 

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.

 

 

 

View solution in original post

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

Thank you @Swapnilmandloi , you idea is so great

Hi, @Powerwoman 

Based on the information you described, I used the following sample data:

vjianpengmsft_0-1720493449887.png

Set the format of the matrix in Report builder to the following style:

vjianpengmsft_1-1720493485573.png

This way, you can get the style you expect:

vjianpengmsft_2-1720493525538.png

 

 

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:

  1. Create a Table Report:

    • Insert a tablix data region and add fields to the Data row.
  2. Add a Parent Group:

    • Select the table, right-click the Details Group in the Grouping pane, and choose Add Group > Parent Group.
    • In the Tablix Group dialog box, provide a name and select a group expression (e.g., a field to group by, such as Category).
    • Check Add group header and/or Add group footer as needed.
  3. Create the Stepped Layout:

    • To create a stepped layout, you can remove the group instance column and adjust the padding for the detail rows.
    • Right-click the group column and select Delete Columns. Copy the group header value to the first cell of the group header row.
    • Select the detail cell and adjust its left padding to indent it under the group header (e.g., set padding to 0.5in).
  4. Add Subgroups:

    • In the Row Groups pane, right-click the existing group, select Add Group, and choose Child Group.
    • Provide a name and select the appropriate group expression for the subgroup (e.g., Subcategory).
  5. Adjust Formatting:

    • Use the Properties pane to apply different formatting to group headers and detail rows to differentiate them visually.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors