Add column subtotal to matrix visual

Question

Hi,&nbsp;I have a matrix visual for my Power BI. How can i add totals for the columns for my values?&nbsp;I have added a screenshot of the table.&nbsp;&nbsp;

kedar_pande · Answer

Make sure the Rows subtotal is turned on:&nbsp;

anonymous · Answer

I got it turned on now but it applies to every row level and not the column level&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi Anonymous&nbsp;,
Based on the description, in Row subtotals, turn on per row level and select Description. Turn off show subtotal.

The matrix shows column total.

You can also view the following link to learn more information.
Solved: Re: how to show grand total only without subtotal ... - Microsoft Fabric Community
&nbsp;
Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

anonymous · Answer

Hi,I want to do this with outline layout.&nbsp;&nbsp;With outline the result is like this:&nbsp;&nbsp;

anonymous · Answer

Hi Anonymous&nbsp;,
Based on the description, choosing the outline layout.

Then, turn on per row level and turn off show subtotal.

Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Add column subtotal to matrix visual

5 Replies

Related content

Customize subtotal in matrix

Matrix subtotal

Matrix column Subtotal

Matrix visual subtotal

Subtotals in Matrix