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