Help needed with Paginated Report having column groups to be vertical instead of horizontal

[xiaois]

Hi all,

Needed some help in trying to achieve ths. 

the column grouping in paginated report only allows me to have the dates as expanding horizontally instead of vertically

	3/1/2025	3/2/2025	3/3/2025
Level	Amount Count	Amount Count	Amount Count
Level 1	1	3	5
Level 2a	23	1	3
Level 3a	2	123	2
Level 2b	1	2	3
Level 3b	2	1	4

note:
1. im not trying to get it whereby my Date is on last level of my rows (after level 3) but rather it will show for all levels.

2. i need it to be matrix (ie having the stepped layout format) instead of table 

Thank for the help!

[v-saisrao-msft]

Hi @xiaois,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @xiaois,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[freginier]

Hey there!

  The issue you’re facing is that column groups (Dates) are expanding horizontally instead of appearing vertically for all levels in a matrix (stepped layout format).

Steps to Achieve Vertical Column Groups (Stepped Layout)

1. Use a Matrix Instead of a Table

   • Ensure you are using a Matrix and not a standard Table.
   • The Matrix allows grouping on rows and columns dynamically.

2. Set Up Row Groups Properly

   • In the Row Groups pane:
     • Add hierarchical levels (Level 1, Level 2a, Level 3a, etc.).
     • Make sure that Date is inside each level so that it repeats across levels.

3. Move Date to Row Group Instead of Column Group

   • Click on the Date field in the Column Group section.
   • Drag it into the Row Groups pane so that dates appear vertically.

4. Modify Column Group Properties

   • Right-click on the Date column group → Select Group Properties.
   • In the Sorting tab, ensure the sorting is based on ascending order of Date.
   • Under Visibility, set "Show if grouped" so that it doesn’t repeat unnecessarily.

5. Adjust Stepped Layout Format

   • In Row Group Properties, enable "Keep Together" and "Stepped Layout".
   • Make sure to merge cells for hierarchy levels where needed.

6. Adjust Totals Placement

   • Right-click the Result row and select “Add Total” if needed.
   • Ensure totals are positioned correctly for each level.

Hope this helps!

😁😁

[xiaois]

Hi freginier,

would you happen to have a sample file i can refer from? as im not able to follow from:

step 2: 'Make sure that Date is inside each level so that it repeats across levels.' do you mean repeating lik this?

and step 3: by pane i assume u referring to the bottom area?

i couldnt drag from the column group to the row group though?

and in step 4:

when i tried to edit the column group properties on visiblity, it does not have the 'show if grouped' field:

thanks!

[v-saisrao-msft]

Hi @xiaois,

The behavior you're seeing is expected since column groups in a matrix expand horizontally by default. To achieve a vertical layout for Date within each hierarchical level while maintaining a stepped matrix format, you'll need to restructure your design. Use a Matrix, not a Table, and define your row groups hierarchically (e.g., Level 1 → Level 2 → Level 3). Then, instead of placing Date in the column group, add it as a child row group under each level. This allows dates to repeat vertically within each group. If Date is already in the column group, you can safely delete that group (select "Delete Group Only") and reintroduce Date in the row grouping area. Make sure to format the stepped layout using padding or indentation, and add totals if needed at each level. Let me know if you'd like a visual guide or sample layout to help illustrate this.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[xiaois]

hi so, by putting it as child group, it will make it such that the expanding/collapse will be Level 1  -> Date -> Level 2 -> Date which is not wanted. regardless i have given up on this so no solutions.

[v-saisrao-msft]

Hi @xiaois,
Thank you for the update on this thread. For further assistance, please use the Microsoft fabric Community:
Home - Microsoft Fabric Community

Thank you.