cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnkoster
Regular Visitor

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.

 

 

Knipsel.PNG

4 REPLIES 4
v-yuezhe-msft
Microsoft
Microsoft

@johnkoster,

Create the Matrix visual following steps as below.
4.JPGClick the third button to expand rowsClick the third button to expand rowsturn on subtotals optionsturn on subtotals options

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Knipsel.JPG

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

 

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. 

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors