Forum Discussion
Helper ILocking Header Rows in grid/table
Hi bdherh
In Power BI, locking (freezing) rows in a table visual is not natively supported. There’s no built-in way to freeze the top N rows of a Table or Matrix visual so that they remain visible while scrolling.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
Hi bdherh ,
Thank you for reaching out to Microsoft fabric community forum.
At this time, Power BI does not support locking or freezing rows in a Table or Matrix visual only columns can be frozen in Matrix visuals as mentioned by ajaybabuinturi
As a workaround you can display your USL–LSL reference rows in a separate static table placed above your main table visual. This way, the reference data remains visible while users scroll through the rest of the table.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
bdherhSo there is not a built in way to do this. Is there a way programatically to perform this?
Thanks
- ajaybabuinturi
Super User
Hi bdherh,
I am not sure about program, but yeah there is custom visual called Custom and Grouped Headers by JTA. It's free on AppSource please try it. I believe still it is in intial stage.Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues. Hi bdherh ,
Thank you ajaybabuinturi the suggestion made regarding the “Custom and Grouped Headers” visual by JTA. This custom visual from AppSource is designed to offer enhanced flexibility in displaying grouped or fixed-style headers, which may help simulate part of your requirement.
As an additional alternative, consider structuring your layout using two synchronized visuals: one visual showing the reference rows (USL to LSL) and a second visual below for the dynamic dataset. This doesn't freeze the rows but can give the impression of a locked header when properly aligned.
Microsoft is continuously improving Power BI's visual capabilities, so I also recommend submitting this as a feature request or voting on similar ideas in the Fabric Ideas - Microsoft Fabric Community.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.