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.

[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).