Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

Freeze / Unfreeze row headers option not available in Power Bi Service

Hi!

I am working on a report of Matrix Visual with Multiple Row headers with Hierarchy of Side by Side. Means +/- icon off and Stepped Layout off. And Since I have many rows, I am using the Freeze / Unfreeze Row headers option in Power BI Desktop by selecting a particular row cell and right click. See the below picture for example

jayasurya_prud_1-1716238175587.png

 

jayasurya_prud_2-1716238191778.png


With the help of unfreeze, if needed I can scroll to extreme right and left. 

But If I try the same by publishing in Workspace, I don't get the freeze and unfreeze row headers option. below image is the ref

jayasurya_prud_3-1716238311115.png


This is the Sample one. But in real PBIX, I have many rows where I can't even scroll horizontally to see the columns and Values. 

Kindly help. I am working with PRO license. 

@amitchandak and any other Superusers. 

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi @jayasurya_prud  and others

This feature will be back to normal work in the coming days. Thank you for your feedback.

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-jianpeng-msft
Community Support
Community Support

Hi @jayasurya_prud  and others

This feature will be back to normal work in the coming days. Thank you for your feedback.

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianpeng-msft
Community Support
Community Support

Thanks @hackcrr 
Hi @jayasurya_prud and others
This is a known issue, and I will reply to you here if there is any progress in the future.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anand-kumar
New Member

As Freeze/Unfreeze option available over a workspace, we had developed reports such to avail this functionality. As M/S removed the option from workspace, the reorts are not giving correct insight for which it has been developed. Now either need to have workaround or need to change the requirement or M/S to bring back the functionality.

sd22
Frequent Visitor

Can anyone from Microsoft confirmt that if the unfreeze row headers functionality is removed from the PowerBi service. It is a bit urgent as if it is removed then we need to redesign the report .

Jollyman
New Member

Hi @jayasurya_prud and @hackcrr .

We are having the same problem on a report published on PowerBi service several months ago. I can say with certainty that the "freeze/unfreeze row headers" feature was also available on PowerBi service: the report was based precisely on the possibility of unfreezing the column headers to see all the data. I couldn't say when this feature was no longer available on PowerBi service, but in our case it was only reported to us yesterday, since our users are unable to use the report as usual.

 

Maybe it was disabled for performance reasons? Does anyone know if there's any chance it can be restored? Otherwise, we will have to redesign the report.

 

Best regards.

hackcrr
Solution Sage
Solution Sage

Hi, @jayasurya_prud 

The freeze/unfreeze row headers feature in Power BI Desktop is a desktop-specific capability that allows you to pin row headers in place when scrolling horizontally within the report view. Unfortunately, this feature is not currently available in the Power BI service (the web version when you publish to a workspace or share with others).

However, there are a few workarounds you can try to improve the experience for your users:

Reduce the number of columns: If possible, consider reducing the number of columns in your matrix visual to make it more manageable within the Power BI service. You can do this by hiding unnecessary columns or aggregating data into fewer columns.

If you have a lot of data and need to display it in multiple pages, you can use pagination to split your matrix visual into multiple pages. This allows users to navigate between pages to view different columns.

Instead of trying to fit all the data into a single matrix visual, consider breaking it down into multiple visuals. Each visual can focus on a specific subset of data, making it easier to view and interpret.

If this is a critical feature for your use case, you can consider submitting a feature request to Microsoft through the Power BI Ideas portal. This allows you to provide feedback and vote on existing feature requests.

https://ideas.fabric.microsoft.com/

 

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors