Freezing Column in Matrix

[Anonymous]

Hi All

I am trying to do exactly the same as described here:

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-freeze-the-two-first-column-into-a-large-...

I have drilled down to the buttom and turned stepped layout off.

I have put NavId and Name T undeer Rows (I would like to set them as fixed Rows) and all other columns are set under Values.

Unfortunately, all values are shown as "First" . What I want is a simple table and each row is showing one customer. At the moment I have for each customer two rows.

Any Advise is highly apreciated.

[amitchandak]

@Anonymous , Not very clear. But do you want to switch off the stepped layout?

refer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Anonymous]

@amitchandak 

Thanks for your reply. Not exactly. I have disabled stepped layout only because it was mentioned in the article that I have posted.  What I want is a simple Table like shown below:

	NavID	Name	Sales 2021	Sales 2020	Sales 2019
Customer 1
Customer 2
Customer 3
Customer 4
Customer 5
Customer 6
Customer 7
	Fixed Column	Fixed Column

Column NavId and Name should be freezed so that these columns are always visible when scrolling to the right side.

It doesn't have to be a matrix.

kind regards

Jonas

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can turn off the Row subtotals.

Furthermore, you can turn off the +/- icons.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.