cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leehbi99 Frequent Visitor
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
Community Support Team
Community Support Team

Re: Matrix is failing with many row fields

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.

leehbi99 Frequent Visitor
Frequent Visitor

Re: Matrix is failing with many row fields

MatrixIssue.PNG

Community Support Team
Community Support Team

Re: Matrix is failing with many row fields

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.

Community Support Team
Community Support Team

Re: Matrix is failing with many row fields

Hi @leehbi99 

If not, please show me your expected result.

 

Best Regards
Maggie

leehbi99 Frequent Visitor
Frequent Visitor

Re: Matrix is failing with many row fields

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 407 members 4,519 guests
Please welcome our newest community members: