Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a paginated report with several row groups and column groups. I need to repeat the 1st & 2nd column group header on each page, but only the 1st column group header is showing on each page. Row group headers are working, and I have set the advanced mode properties to repeat with each page on. Has anyone else experienced this issue? I have created several reports that repeat the desired group headers on each page, but I have tried every option that I can think of of on this report. Any help would be greatly appreciated. Thanks in advance!
Hi @MSM2023 ,
Please try below steps:
1. Open your report in the Power BI Report Builder.
2. In the report layout, click on the tablix member (the small gray square) that represents the column group you want to repeat.
3. In the Properties pane, find the `RepeatOnNewPage` property and set it to `True`.
4. Ensure that the `KeepWithGroup` property is set to `After` for the header you want to repeat.
5. Also, check the `FixedData` property and set it to `True`. This ensures that the header is fixed while scrolling.
6. If you are using Advanced Mode in the Groupings pane, make sure that the `RepeatOnNewPage` property is set to `True` for the static member representing the header row.
7. Preview the report to see if the changes are reflected.
If the second column group header is still not repeating, it could be due to the specific layout or configuration of your report. Here are a few additional things to check:
- Ensure that there are no overlapping or nested objects that might be interfering with the header repeat functionality.
- Verify that the tablix properties are correctly configured for all groups and static members involved.
- Check if there are any conditional visibility expressions that might be affecting the display of the second column group header.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
4 |