Forum Discussion

mgibson44's avatar
mgibson44
Frequent Visitor
8 years ago

Need Cumulative Total On Matrix Chart

 

In PowerBI I have a Matrix table that looks similar to this. It shows the totals under the month, but I can't figure out how to get it to show the total for January+February+March in the Total columun to the right. I used quick measure to get the monthly totals. Thanks for the help. 

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi mgibson44,

     

    Have you turned on the subtotals for column subtotals under Format for Matrix?

     

     

    If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

    • mgibson44's avatar
      mgibson44
      Frequent Visitor
      8 years ago

      Thank you for your help. The column subtotals are turned on yet the totals column is still empty. 

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi mgibson44,

         

        That's really strange.

         

        If it is convenient, coud you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

         

        Best Regards,

        Cherry