Forum Discussion

johnkoster's avatar
johnkoster
Regular Visitor
8 years ago

Matrix (sub)totals / end total

Hello,

 

I'm looking for a solution for the following problem:

When I'm using the matrix tool and I have defined that the columns are Company (i.e.: Company A & B) and year (i.e.: 2017 & 2018), then I want a endtotal colum which shows the endtotal per year. Thus total amount Company A + B for 2017 as a totalcolum and Company A + B for 2018 as a totalcolum. Currently I only get a total column (see below).

 

In a pivot table in Excel this is a standard option.

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    johnkoster,

    Create the Matrix visual following steps as below.
    Click the third button to expand rowsturn on subtotals options

    Regards,
    Lydia

    • johnkoster's avatar
      johnkoster
      Regular Visitor
      8 years ago

      Thanks for you explaination. Unfortunately this is not what I want. 

       

      I would like to have column Total which summarizes by year. Example see below (created in Excel):

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        johnkoster,

        It is not possible to create exact same Matrix visual as Excel in Power BI Desktop. You may need to sumit an idea in Power BI ideas forum.

        The Martix I provide also display A+B data for 2017 and 2018, it only displays the data in a different format.

        Regards,
        Lydia