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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
bhalicki
Advocate II
Advocate II

Powerbi matrix choose which column to freeze

Hi all,

 

I'm looking for a way to select which column is frozen using the matrix visualisation.  From what I can see, it is only possible to freeze the first column. 

Also I would like to include several fixed columns after the frozen pane but cannot find an efficient way to do this.  I have been setting up the column I want frozen as a "row", then adding the columns I want to appear after the freeze pane as "values".  Any dynamic columns I then add as parameters using measures (so that the column headers are dynamic).  Works when I have a small data set, but my client has just requested I increase the number of columns from 5 to 20 which kills performance.

bhalicki_0-1739950307013.png

Kind regards,
Ben

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@bhalicki  I am afraid to say that as of now no option to freeze the columns except those available in Row section.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

2 REPLIES 2
bhalicki
Advocate II
Advocate II

Thanks @Tahreem24 , I feared that might be the case.
Kind regards,
Ben.

Tahreem24
Super User
Super User

@bhalicki  I am afraid to say that as of now no option to freeze the columns except those available in Row section.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors