Forum Discussion
Solved
Matrix 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...
Found a working workaround...
https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/555009
StuartSmith
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.
Found a working workaround...
https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/555009