1085
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
STATUS DETAILS
Needs Votes

Comments

J

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

J

Was this idea ever implemented?

J

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

J

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.

J

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

J

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

J

i need it

J

Can't believe this is not an option....

J

This is a really simple idea and would add another great bit of functionality, please make it happen Power BI

J

This will definitely be a good feature to have. Hope MS will add it in future. But there is a work around for this problem, following are the steps

1) Create a copy of the original table visual
2) remove all the fields from the duplicate table except for the first column(assuming that is the Colum you want to freeze)
3) Shrink that same column in the original table to the minimum width
4) align these 2 tables together

Cons

1) The column width can not be reduced to 0 to almost make it not visible, so not only shrinked the column to the min size but I also moved it to the end of the table
2) Sometime when you remove columns the granularity of the table changes and the 2 tables are not in sync. work around keep the lowest granular column in the duplicate table and hide it.
3) when sorting is used on any of the tables then the other table does not sort, obviously! I do not have a work around for that.
4) when the data is exported, the main column(that is almost hidden will be exported) is moved to the end of the table. work around, DONT move it to the end after shrinking!!! but you will see a strange space which you can hopefully hide when aligning the 2 table

please let me know If anyone has a workaround for problem 3! Hope this helps!