Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
8 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
10 | |
6 | |
5 | |
4 |