Freeze pane option in Table or Metrics table

[SantoshRaoBomm1]

Hi,

I have a table with multipule columns where i have to freeze first two columns Skill and Track should be in same poistion and reset of the columns data can be movable.

Please let us know how to get the solution for the same.

Regards

santosh kumar

[v-pgoloju]

Hi @SantoshRaoBomm1,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @SantoshRaoBomm1,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @SantoshRaoBomm1,

Just following up to see if the responses provided was helpful in addressing your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @SantoshRaoBomm1,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Vijay_Chethan , @ajaybabuinturi , and @danextian  for their prompt and helpful responses.

Just following up to see if the workarounds suggested by @Vijay_Chethan  and @ajaybabuinturi  were helpful in addressing the issue of freezing the first two columns while allowing horizontal scrolling. As column freezing is currently not supported in Power BI tables, and if this feature is critical for your use case as noted by @danextian you may consider raising it as an idea in the Power BI Ideas forum.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[ajaybabuinturi]

Hi @SantoshRaoBomm1,

Wanted to let you know that there is NO Column Freezing option available in Power BI application. However I would suggest a workaround. If it suits for your business needs, you can go with that workaround. Follow the below steps. 

1. Create two separate table visuals:

• Left Table: Add only Skill and Track columns.
• Right Table: Add only month columns

1. Align them side by side so they appear like one continuous table.
2. Place both visuals in a group (Ctrl + Click both > Right-click > Group) so they move together in formatting or placement.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[Vijay_Chethan]

May not work exactly how intended to , if data overflow, then it wont scale vertically

[Vijay_Chethan]

Hello SantoshRaoBomm1,
You can use matrix visual instead of Table visual for your use case,
add your two columns which are not supposed to be moved as rows for matrix visual and do folllowing setting:

if This helps please mark as solution

[danextian]

Hi @SantoshRaoBomm1 

Power BI tables and matrices don't currently support custom freezing. Only column and row headers are frozen. If this is important to you, you may post this as an idea. https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas 

You can however make a matrix look like it is a table by using the Tabular layout, disabling row subtotals and enabiling Repeat row headers.