Forum Discussion
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 matrix is grouping rows. See below, the table visual correctly shows 3 rows for "OBO ID" 310, bu the Matrix is only showing one row.
How can I get all rows showing in the Matrix?
Found a working workaround...
https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/555009
6 Replies
I have found if I add the "Budget Millions" column into the Matrix "Row" field, it then displays the correct rows, but I dont want the "budget Millions" column in the "Frozen" section of the matrix.
StuartSmith , Matrix rows are frozen not values. but if Budget Millions is a column in row is should be frozen?
The problem is, the matrix is grouping "Budget Millions" (see below) and it doesnt give the me option to "Dont Summerise".
What I want it to do is... but dont know if it is possible or i am not doing something right.
