Skip to main content

Power BI

Needs Votes

freeze column in a table chart

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

8fc93ed4 df4d-4599-833b-dd1ebde7610b 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

5443224a efcc-49e5-b052-8fa7eb4146f0 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

420143fe 989d-4604-914e-2bf52ac48387 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

79f30727 f89d-4e8d-856a-d6a8e0ffb097 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

83b33981 ceed-4aaa-af38-b0545a6921e0 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

0825b247 5ea0-4bb1-875a-e3bfc82527cf 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

a92640e2 9aa9-4bbe-ac79-fd46e98c9402 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

51cc98ef 992b-4af9-8963-d19337c85930 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

bfbc590d 5963-48f6-8580-11a333404047 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.

Jordan Kline's profile image Profile Picture

db98fbf3 a880-4d98-85fc-7d45742c0c69 on 05 Jul 2020 22:56:07

RE: freeze column in a table chart

i'm a pro user, my boss asking for this, please help!