Fix Column and Row Headers not working on Web Layout

[jolopez]

Hi,

I am trying to fix the column and row headers on Power BI Report Builder and it works when I run the report in the app but when I run the report in the Web Layout after its published, the report does not fix the column or row headers.

Here are some pictures of the Groups and Properties of the table.

I tried by using the properties of the groups instead and changing the values of FixedData, KeepTogether and RepeatOnNewPage to true but it doesn't seem to work on the Web Layout.

If any more info is needed just let me know.

Thanks!

[demigi15]

I am facing the same issue the scrolling is happening in app once i published on web the scrolling dosent seem to work

need immediate solution on it

[v-jianboli-msft · Accepted solution]

Hi @jolopez ,

A table, matrix, or list data region in a paginated report can span multiple pages horizontally or vertically. You can specify whether to repeat row or column headings on each page. In an interactive renderer such as the web portal or report preview, you can also specify whether to freeze row or column headings to keep them in view when you scroll across or down a report. In a table or matrix, the first row usually contains column headings that label data in each column; the first column usually contains row headings that label the data in each row. For nested groups, you might want to repeat the initial set of row and column headings that contain group labels. By default, a list data region does not include headings.

How you control whether headings repeat or freeze depends on the following:

• For column headings that repeat at the top of each page:

  • Whether the table or matrix has a column group area that expands horizontally.

  • Whether you want to control all rows that are associated with column groups as a unit.

• For row headings that repeat along the side of each page:

  • Whether the table or matrix has a row group area that expands vertically. Row headings are supported only for row groups with a row group header.

For more details, please refer to:

Control row & column headings in a paginated report - Microsoft Report Builder & Power BI Report Bui...

Page layout and rendering in paginated reports - Microsoft Report Builder & Power BI Report Builder ...  

Controlling page breaks, headings, columns, and rows in paginated reports - Microsoft Report Builder... 

Best Regards,

Jianbo Li

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