Matrix with left hand totals

[Anonymous]

A matrix visual shows totals on the right.

It can be annoying to scroll far right to see them.

Is it possible to show them in the left?

I see that this request has been voted for many times since 2017

Does anyone know  ....

•  is there a matrix on the app store that has a left hand total option?
•  is there any work arroud with dax, custom visuals, etc?
•  if and when the voted request will become avaiable?

Many thanks, Ramps

[Syndicate_Admin]

This solution is very useful in case the table has a single level of hierarchy, but with several levels it no longer works.

Will there be possibilities that this is fixed from the visual object and that directly choose if you want to put the total to left or right as with the total of rows?

Thank you very much for reading.

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

You could try me way:

I make a sample table as below to have a test.

Build a Metrix visual:

Let’s create a calculated column.

Total = CALCULATE(SUM('Table'[Column2]),ALLEXCEPT('Table','Table'[Column1]))

Drag Total Column into Rows in Fields.

Result:

Let’s turn off the Stepped layout and the Column Subtotal.

Result:

If you turn on Row subtotals, the matrix will show as below, this looks not good.

Currently, there is no way to change the column subtotals to left. Please click the Idea link below and vote for this function.

Idea Link: https://ideas.powerbi.com/ideas/idea/?ideaid=fa4c855b-67ce-4970-b4ee-72226772ba79

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EQ5iQs31MzdGs_joYPXsVTgB9hnSkkUT9w77HsankCPDOQ?e=0QJISb

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

here is a quick thought what if you try to create a totals measure and then make that your first column in your matrix.  Then turn totals of for your matrix.  

i have done something similar in the past and it worked nicley