Forum Discussion
Help needed with Paginated Report having column groups to be vertical instead of horizontal
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.
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-msft1 year ago
Community Support
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.