Matrix is failing with many row fields

[leehbi99]

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?

 

[v-juanli-msft]

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]

[v-juanli-msft]

Hi @leehbi99 

If not, please show me your expected result.

Best Regards
Maggie

[leehbi99]

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.

[v-juanli-msft]

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

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.