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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.