Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MSM2023
New Member

Paginated Report not repeated second column header group on export to pdf

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!

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors