Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
leehbi99
Frequent Visitor

Matrix is failing with many row fields

I'm working with a customer who wants a sub-total table.  I'm using the Matrix to do this.   The issue is the customer has many fields.   The pane is frozen hence the values are not visible as they are pushed off the screen.   The horizontal scrollbar only applies to values but as these aren't visible the Matrix is not usable.   Do Microsoft have any plans to fix this?

 

5 REPLIES 5
v-juanli-msft
Community Support
Community Support

Hi @leehbi99 

I can’t reproduce your problem, could you show me a screenshot?

Do you use the last version Version: 2.71.5523.941 64-bit (July 2019)?

If your requirement is to get correct subtotal in a matrix, please use DAX function like

IF(HASONEVALUE( [column]),1,2)

Inscope

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MatrixIssue.PNG

Hi @leehbi99 

If not, please show me your expected result.

 

Best Regards
Maggie

Hi Maggie,

The user wants the dataset column names in columns on the matrix as you can see in the screen below.  I gave them the option to put columns on rows as you suggested but that is not acceptable.   The only other workaround is to create measures for each table column - this lets them be placed on the Values section of the report - I don't like this as I don't want to create measures for non-measure data.

 

You should note, in my real data the dataset column names are named with business entities.   It's 1 de-normalised flat table.

 

What I really want is for the matrix to scroll horizontally just like the table.  Maybe build a setting to turn off freeze panes !   The matrix works fine with around 8 columns.  I've created a sample of what I'm looking for, as you can see the matrix works fine with columns that fit on the screen.   As as soon as the matrix is too wide to fit on the screen we lose the values.    I've also tried putting the Values on Rows but this is not acceptable either.

 

MatrxTest2.PNG

Hi @leehbi99 

Do you have a table as below:

col1 col2 col3 col4 col5 col6 col7 cost sales
a b c d e f g 1 2

 

But you want to add it in the matrix and view as below

Capture6.JPG

If so, in Edit queries, select "sales" and "cost" columns, then select "unpivot other columns".

Close&&apply.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors