Forum Discussion

MikeEcho's avatar
MikeEcho
Frequent Visitor
9 years ago
Solved

Multiple Totals At bottom

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...
  • MikeEcho's avatar
    MikeEcho
    9 years ago

    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.

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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,