Add column subtotal to matrix visual

[Anonymous]

Hi,

I have a matrix visual for my Power BI. How can i add totals for the columns for my values?

I have added a screenshot of the table.

[Anonymous]

Hi @Anonymous ,

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

Best Regards,

Wisdom Wu

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

[Anonymous]

Hi,

I want to do this with outline layout. 

With outline the result is like this:

[Anonymous]

Hi @Anonymous ,

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 helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kedar_Pande]

Make sure the Rows subtotal is turned on:

[Anonymous]

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