Freeze columns in Power BI tables or matrix

[DanielRichard]

I know this is an requested feature and I have seen "workarounds", but unless I am missing something, there is not a way to get what I need.

My report has only data. There are no calculations or summary values.

There are more colums in the data, but this should give you the idea.

I want to freeze the Status column. The suggestions I found all seem to deal with summary values or calculations. The matrix option only allows for summarized values in the colums - First Value, Last Value, Count (Distinct), Count. I need this data to appear exactly like it would in Excel if you freeze the first column.

Has anyone come up with a work-around for this?

[Ritaf1983 · Accepted solution]

Hi @DanielRichard 
Since we have a "tabular layout" of the matrix you can get with it the "flat" table view with a freezing row headers.

I don't think there are better alternatives for your request with the core visuals.

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @DanielRichard 
Since we have a "tabular layout" of the matrix you can get with it the "flat" table view with a freezing row headers.

I don't think there are better alternatives for your request with the core visuals.

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[DanielRichard]

Sorry, but I must have missed something. the tabular view works, but now I don't see a horizontal scroll bar and I can't even "tab" over to the hidden columns.

I used your pbix file and created the report layout that I used for my data (I didn't see the one you had in your screenshot). 

  

[Ritaf1983 · Accepted solution]

Hi @DanielRichard 

The combination of scrolling and freezing is currently available only when scrolling is for measures, not for categories.

This means that all categories need to fit within the visible area of the table. Since the matrix is designed for aggregations, there is no way to address each category separately.

The u[dated PBIX is attached

There is an idea on this topic. I’ve added your input as a comment to the suggestion and will also share it with my colleagues in the groups I manage.

Here’s the link—please vote for it

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8ac0cb6e-ac17-eb11-8441-281878bda85b

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[DanielRichard]

Thanks.....