Forum Discussion
StuartSmith
Power Participant
5 years agoMatrix is grouping rows.
I originally had a table visual showing data, but then decided I wanted the first n columns frozen when scolling to the right and therefore had to use a matrix instead. The only problem is, that the...
- 5 years ago
Found a working workaround...
https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/555009
PaulDBrown
Community Champion
5 years agoStuartSmith
Apologies if you know this already, but just in case...
To see the values line by line you need to expand the rows. Here is an example:
A simple matrix with several rows and one measure: notice how only the top level hierarchy is visible, and the values are grouped:
If you right-click on the "Channel" field in the matrix visual, you get options:
And you get this (you can format the row options under "Row Headers" in the format pane for the matrix visual)
Again, apologies if you were already aware of this.
StuartSmith
Power Participant
5 years agoFound a working workaround...
https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/555009