add rows after total

[CUDataArchitect]

This image shows 2 separate matrix (matrices). Is there a way to combine these so they will still display with the "category" on top and the "savings' below to total of the category? I'm unhappy with keeping them separate because the height of the 1st matrix varies each time we use it, so the second matrix (containing the savings) doesn't butt up against the first chart. 

[v-yulgu-msft]

Hi @CUDataArchitect,

As of now, it is not possible to add extra rows under "Total" row in a Matrix. If you want to combine above two matrix, you could generate separate measures to get values of "Monthly saving" and "% Savings", add measures to the "values" section of the first matrix, then, two extra columns would be displayed in matrix.

Regards,

Yuliana Gu

[Seward12533]

PowerBI doesn't really let you do what you want.  You could hack it but would not be dynamic and it will require you to write a measure to calculate the amount for each category

Transactions Measure = CALCULATE([Amount],table[Category]="Transactions"

etc...

You coudl then put them in a Matrix Visual with the formatting set to display columsn on rows and add each of your individual measures into the values of the Matrix along wiht yours savings. 

What I usually do is put a Card, Guage or other simple visual off the side with the other measure.

There are some other hacks in PowerPivot for Excel that woudl allow you do what your trying to do without writing all the extra measures but they won't work in PowerBI.   I saw an announcment that there is a pending release of PowerBI that will have paginated report capabilties and this might have the functionality your after but I dont' think there will be many details about it befor the upcomming BI Summit next week in Seattle.

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-self-service-prep-for-big-data-unifies-mod...