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 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

 

  • 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.

5 Replies

  • 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,

     

  • MikeEcho's avatar
    MikeEcho
    Frequent Visitor
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

      Thanks in advance!

  • Ian-IKS's avatar
    Ian-IKS
    Regular Visitor
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     

    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