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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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