Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

freeze column in a table chart

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: Needs Votes
Comments
sandeeppunreddy
New Member
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!
fbcideas_migusr
New Member
This is a really simple idea and would add another great bit of functionality, please make it happen Power BI
rcalvo
Frequent Visitor
Can't believe this is not an option....
sajidmansooral1
New Member
i need it
log_pb011
New Member
i'm a pro user, my boss asking for this, please help!
sandip_mukherje
New Member
I believe the option is to use MATRIX and keep MATRIX's style as CONDENSED. That way 1st column can be freezed.
Tony_Ferreira
New Member
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.
joel_faltermeie
New Member
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
daniel_william3
New Member
Was this idea ever implemented?
priresearch_33
New Member
It will be a nice feature like we freeze columns for Excel