Forum Discussion
Freezing Column in Matrix
Hi All
I am trying to do exactly the same as described here:
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.
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.
3 Replies
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/
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
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.
