Skip to main content

Power BI

Needs Votes

freeze column in a table chart

Vote (1654) 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 (95)
Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:40

RE: freeze column in a table chart

Fixed column in absolution required for the large tables

Jordan Kline's profile image Profile Picture

KayP on 05 Jul 2020 23:39:38

RE: freeze column in a table chart

Column freeze in a table is a critical feature with large tables. Without this feature, you do not know where you are in table and must continue to scroll to determine where you are.

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:12

RE: freeze column in a table chart

Turn the table to matrix, then one row is frozen. Limited but helpful.

Jordan Kline's profile image Profile Picture

VickyD on 05 Jul 2020 23:32:38

RE: freeze column in a table chart

It would be nice if Microsoft can identify little things like these and implement first. Sometimes the most powerful way of looking at data is via table and matrix visuals so if these 2 visuals can be nailed first it would be great.

Here are few things I'd love to see:-
1. Freeze columns
2. Conditional Icon sets
3. Sparklines
4. Filters within table columns
5. Explicit formatting control for headers, rows, totals.
6. Conditional formatting of text fields based on their own value
7. +/- to expand collapse (this is coming)

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:46

RE: freeze column in a table chart

It will be a good feature to have. It can help the business users to read the data available and understand where they are.

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:15

RE: freeze column in a table chart

It will be a nice feature like we freeze columns for Excel

Jordan Kline's profile image Profile Picture

Danny on 05 Jul 2020 23:20:15

RE: freeze column in a table chart

Was this idea ever implemented?

Jordan Kline's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:06:05

RE: freeze column in a table chart

Same idea as this:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9472428-allow-columns-to-be-locked-in-tables-for-when-scro

Jordan Kline's profile image Profile Picture

Tony Ferreira on 05 Jul 2020 23:05:44

RE: freeze column in a table chart

definitely missed,
I have 30 plus columns and Power BI does lend itself well to scrolling left and right, scrollbar is quite thin, disappears and is not well contrasted so quite a mission.

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 22:58:49

RE: freeze column in a table chart

I believe the option is to use MATRIX and keep MATRIX's style as CONDENSED. That way 1st column can be freezed.