Skip to main content
Microsoft Idea

Power BI

Needs Votes

freeze column in a table chart

Vote (1555) 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 (91)
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-bab42a8ffdb1


That'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 ??

Jordan Kline's profile image Profile Picture

Juan Pablo on 08 Nov 2022 03:39:38

RE: freeze column in a table chart

Please, we have asked for this for a long time and is so basic and useful. You already have much of the work done in the matrix, just move it to the table visual.

Thank you.

Jordan Kline's profile image Profile Picture

Brett Smith on 11 Oct 2022 20:06:14

RE: freeze column in a table chart

Essential (and simple) feature needed. The matrix work around loses too much other functionality to be used all the time