Forum Discussion

bdherh's avatar
bdherh
Icon for Helper I rankHelper I
1 year ago
Solved

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 scroll...
Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
bdherh
Icon for Helper I rankHelper I
1 year ago

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

Thanks