subtotals on the bottom of the matrix

[Anonymous]

Hi,

In my dataset I have 16 rows divided into 4 groups (A, B, C, D):

I have a matrix visual with the subtotals for each group:

Is it possible to move all subtotals to the bottom of the matrix (so all subtotals are after the detail rows, and all subtotals are next to each other)? I would like to achive something like this:

Is it possible to achive this with the matrix? Or is there any other visual which allows to do this?

[PaulDBrown · Accepted solution]

@Anonymous 

I don’t think that is possible. But why not use the “collapse row” feature in the row header under the format pane? 

[v-yuta-msft]

@Anonymous ,

I'm afraid a single visual we can't achieve this because we can not add specific rows in a visual. As a workaround, I would suggest you to create a measure [SubTotal] using DAX below and drag [Group] and [SubTotal] to a table visual.

SubTotal = CALCULATE(SUM('Table'[Value]), ALLEXCEPT('Table', 'Table'[Group]))

 

Community Support Team _ Jimmy Tao

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