Multiple Totals At bottom

[MikeEcho]

I am brand new to Power BI, but learning this AWESOME software quickly.

I have a visual to setup, most of it I can manage, however my problem is once I have my multiple totals calculated, how do I get them to display at the bottom of my table/matrix.

I included a sample (links is to an excel and image showing the same sample) showing what I am trying to achieve.
I have managed to workout how to get all the different totals, I just don't know how to get them to display as per the links?

Any help or guidance would be appreciated 😉

ecolpay.com/powerbi/question1.xlsx
ecolpay.com/powerbi/question1.jpg

[Anonymous]

I have this a Json file and it still loads as a "Top" position ...... if I manually change to "top" and then back to "bottom" it works .... very strange.... not solved 

[Ian-IKS]

You can put the total at the bottom in the format section under subtotal where there is an option to show the total at the top or bottom

[MikeEcho · Accepted solution]

Thanks for the reply Simon_Hou-MSFT, I kind of realized that, after searching everywere for an answer 😉

I managed to do my own workaround to have as many row totals at the bottom of the table as I needed (In my case 7)

Thanks anyway, and I hope they do add multiple row totals to Power BI as it is definately the BEST, most feature rich, and most developer FRIENDLY BI product I have ever used.

[Anonymous]

Hi! Can you share your workaround with us? I am looking as well for a solution to this.

Thanks in advance!

[v-sihou-msft]

@MikeEcho

Unfortunately, it's not supported to custom calculation on Grand Total level in any Power BI Desktop visual. You may submit a feature request on idea. 

And I assume your .xlsx is not your underlying source data. It supposes to have a variance column and date column so that you can aggregate those balance up to current date. If you need to individually create measures for those calculations, please share some underlying source sample data.

Regards,