Skip to main content

Power BI

Needs Votes

freeze column in a table chart

Vote (1640) Share
Jordan Kline's profile image

Jordan Kline on 29 Jan 2015 10:25:15

It'd be great to be able to freeze a left hand column in a table so users can scroll and keep track of what row they're looking at

Comments (93)
Jordan Kline's profile image Profile Picture

Cyril JACQUET on 08 Oct 2024 07:30:44

RE: freeze column in a table chart

Please do implement the option to freeze left pane using a table (not matrix), we're in 2024 and still not able to do that is immensely frustrating...

Jordan Kline's profile image Profile Picture

on 01 Oct 2024 00:23:19

RE: freeze column in a table chart

such basic functionality yet huge difference maker, please do it guys.

Jordan Kline's profile image Profile Picture

Burak Demirtas on 26 Mar 2024 19:33:34

RE: freeze column in a table chart

Such a basic functionality and still missing since 2 years... There are also other related ideas pending. Is someone checking and grouping those ideas in the same pool? Example: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=560f6eaa-f1ff-4e72-954c-bab42a8ffdb1That's absolutely needed feature for "Table" visual. Please work on it @Microsoft! 🙁

Jordan Kline's profile image Profile Picture

Elizabeth McDonald on 02 Feb 2024 13:47:34

RE: freeze column in a table chart

I wonder how many votes an idea needs before it goes under review. If you search Fabric Ideas for "freeze", you'll find many others asking for this. While I understand Power BI is not Excel and has many benefits over Excel, the lack of being able to freeze panes (e.g., freeze the 2 left columns) is perhaps the only item I find myself embarrassed about when I have to tell stakeholders I can't implement this simple request ...and do you know what behavior a lack of freeze panes encourages in end users? Exporting to Excel, the very thing we are trying to coach out of them 😪

Jordan Kline's profile image Profile Picture

Shashank Chavan on 18 Aug 2023 11:31:05

RE: freeze column in a table chart

I have achieved the freezing of first few columns using Matrix visual instead of table visual and managed to represent the data like table visual only using stepped layout for row_headers property in formatting. But recently I received the request on top of it to sort the first few columns like we do the sorting by clicking on column header in any other regular table visual. When I had tried to to do the same then i end up facing another issue that only my first column was sorting after clicking on column header and remaining columns were not at all sorting post clicking on the column headers. I guess this is happening due to row level hierarchy which gets created in the background even though we are showing the row level details onto the columns. @Microsoft : Please provide the required feature to be able to freeze few textual data columns using simple table visual instead of using matrix visual and painful process of workaround to achieve the table like representation.

Jordan Kline's profile image Profile Picture

Sreenivas Battula on 13 Jul 2023 01:45:09

RE: freeze column in a table chart

This is one of the good features for table view , i was recently asked to implement in one of the report.

Jordan Kline's profile image Profile Picture

Jan Lemke on 25 Apr 2023 13:02:12

RE: freeze column in a table chart

Hey Microsoft,you have the feature in Excel. (Just first column but hey better then nothing)How could it be, that after 8 Years this feature isn't implemented in Power Bi?Any reaction would be very nice for all the people searching for this.

Jordan Kline's profile image Profile Picture

guillermo bermejo on 27 Feb 2023 12:16:11

RE: freeze column in a table chart

How can this still not be available?

Jordan Kline's profile image Profile Picture

Amar Khaliq on 25 Jan 2023 11:54:11

RE: freeze column in a table chart

Very good idea, I was recently asked to implement this in a report recently but found out that I couldn't, this would be especially useful when freezing the id columns as you could reference back to the id being looked at, or for a certain value and you want to check its id, At my work I am always creating wide tables that have over 50 columns so great idea.

Jordan Kline's profile image Profile Picture

Abdelqader Almanaseer on 25 Jan 2023 11:39:55

RE: freeze column in a table chart

Any Update here MS ??