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), th...
Need Help
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

    • johnkoster's avatar
      johnkoster
      Regular Visitor
      8 years ago

      Anonymous

       

      Thanks. The solution presented by you I already tried. That isn't format I wish to present the numbers. I posted this a new idea.