Forum Discussion
Locking Header Rows in grid/table
I have a Table object that is populated from a SqlServer table. I need to have the first 6 rows locked when the user scrolls down so they wont disappear. Is this possible? For example, when scrolling down, the USL-LSL plus P150 stays visible
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.
7 Replies
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.
So there is not a built in way to do this. Is there a way programatically to perform this?
Thanks
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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi @elinevans1 ,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.
