Locking Header Rows in grid/table

[bdherh]

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

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[bdherh]

So there is not a built in way to do this.  Is there a way programatically to perform this?

Thanks

[v-tsaipranay]

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.

[ajaybabuinturi]

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. 

AppSource - https://appsource.microsoft.com/en-us/product/power-bi-visuals/jtathedatascientists1592432854663.tab...

Demo Dashboard - https://app.powerbi.com/view?r=eyJrIjoiZTU5MWZiOWYtMmNhMi00MjYzLWFmYTctYjNiYjk4ZjFkNWQxIiwidCI6IjRhZ...

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.

[ajaybabuinturi · Accepted solution]

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.