Scrolling Column header issue for paginated report visual

[Anonymous]

We have created paginated report and published in services. In that around 20 columns are available in the report. also around 5 feild parameters are included.

Now the issue is when we see report in services we are unable to see coulmn headrers, when we switch to next page or scrolling  down. 

We have enables 2 of the tablix properties option - Repeat headers for each page and Keep header visible for scrolling. 

But still this is not working and we are not able to see column headers in next page & scrolling down.

[Anonymous · Accepted solution]

Hi @Anonymous 

If I understand correctly, you need to keep the header visible while scrolling through the paginated report.

The following methods are for your reference:

How you control rows and columns depends on whether you are using a table or a matrix. If it is a table, configure the static members (row and column headings) to remain visible. If it is a matrix, configure the group headings of the rows and columns to remain visible.

If it's a matrix, the setup is as in your screenshot.

If it is a table, the operation is as follows:

1. On the design surface, select anywhere in the table to display static members, as well as groups.
2. On the right side of the grouping pane, select the down arrow, and then select “Advanced Mode”.
3. Click the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the “Tablix Member” properties.
4. In the Properties pane, set “FixedData” to True.

If the problem persists, please try using a different browser to check.

For more details, you can read related document link:

Keep headers visible when scrolling through a paginated report - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.