Forum Discussion
Freeze top header
how to freeze top header just like EXCEL while scrolling power bi dashboard in fit to width page layout.
Hi Anonymous ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Currently, Power BI does not support freezing or pinning a section of a report page (like buttons or visuals) to remain fixed while scrolling, unlike Excel’s “Freeze Panes.” This is a known limitation and not listed as a bug, since it's a missing feature rather than a functionality issue.If this capability is important to your workflow, I highly recommend submitting or voting for it on the Power BI Ideas forum. Microsoft product teams monitor this platform actively when prioritizing features for future updates.
Please go through the below following link for request for the feature on Microsoft Fabric Ideas.
Fabric Ideas - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Thank you,
Menaka
7 Replies
There isn't a direct way to do that in a Power BI table or matrix visual. Alternatives exist. You could overlay another visual to mimic the behavior of a "frozen" row. If your column names are fixed, you could overlay an image of those names. If they are dynamic, you could overlay a card visual or a set of buttons that resolve to the column names. None of those work if you want to "scroll right". You could make your table in Vega (not Vega-Lite, although you could probably get creative with faceting and customizing headers and make it work) and use "sticky" headers. If you're uninitiated with Vega that would take considerable effort.
A paginated report would be another alternative.
Power BI doesn't support freezing headers like Excel. But here's a simple workaround:
- Set page to "Fit to Width" (in View settings).
- Use a tall page (Canvas height: e.g., 3000px).
- Place header (title, slicers, KPIs) at the top and keep that area clear.
- Keep all scrollable visuals below the header.
In Table/Matrix visuals, column headers stay fixed inside the visual automatically — no action needed. This gives a “frozen header” feel while scrolling.
Hi BhavinVyas3003
In my scenario, I have multi visuals & multiple buttons for page navigation at top. So I want to display all buttons everytime during scroll down. I attached screenshot just for reference.Hi Anonymous ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Currently, Power BI does not support freezing or pinning a section of a report page (like buttons or visuals) to remain fixed while scrolling, unlike Excel’s “Freeze Panes.” This is a known limitation and not listed as a bug, since it's a missing feature rather than a functionality issue.If this capability is important to your workflow, I highly recommend submitting or voting for it on the Power BI Ideas forum. Microsoft product teams monitor this platform actively when prioritizing features for future updates.
Please go through the below following link for request for the feature on Microsoft Fabric Ideas.
Fabric Ideas - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Thank you,
Menaka
Hi Anonymous
Power BI doesn’t have an option to freeze the top header like Excel. Anything you put at the top (buttons, slicers, text) will scroll with the page. The only place you can freeze headers is inside a Table or Matrix visual using the “Keep headers visible” setting, but that won’t affect the whole report page.
To repeat the header on every page, break a long dashboard into smaller pages, or if you’re embedding the report in a website, use HTML/CSS to keep a header fixed outside the report.
