Skip to main content

Power BI

Needs Votes

freeze column in a table chart

Vote (1597) 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

Chetan on 05 Jul 2020 23:53:55

RE: freeze column in a table chart

If this is possible in Power Pivot, why is it taking a long time to implement it in PowerBI

Jordan Kline's profile image Profile Picture

Amanda B on 05 Jul 2020 23:53:30

RE: freeze column in a table chart

How is this still not a thing. Please add this capability!

Jordan Kline's profile image Profile Picture

Ali on 05 Jul 2020 23:52:30

RE: freeze column in a table chart

Matrix is an option but you can't order value columns in matrix only the first column

Jordan Kline's profile image Profile Picture

Van on 05 Jul 2020 23:50:44

RE: freeze column in a table chart

Do we have enough votes now to implement this change?

Jordan Kline's profile image Profile Picture

Mary Taylor on 05 Jul 2020 23:48:18

RE: freeze column in a table chart

How has this been open since 2015!?

Jordan Kline's profile image Profile Picture

Adi Kablar on 05 Jul 2020 23:42:47

RE: freeze column in a table chart

I hope they fix this ASAP

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)