cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Matrix - How to remove the grand total and keep subtotals?

Hello,

 

Is there a way to keep the subtotals and remove the grand total in a matrix?


For example, in the following matrix, it doesn't make sense to add values for multiple years of sales (thus, also to keep a grand total row), but it is necessary to add values for different months in the same year:

 

Capturar.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

Download the latest version and refer to picture below.

Capture.PNG

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

View solution in original post

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On and then Per row level slider.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Prodigy
Post Prodigy

Re: Matrix - How to remove the grand total and keep subtotals?

@v-chuncz-msft thanks, but it's not working..

 

Capturar.JPG

 

I can either remove ALL subtotals or enable them ALL, but can't find out how to remove the grand total only.

Highlighted
Community Support
Community Support

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

Download the latest version and refer to picture below.

Capture.PNG

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

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Matrix - How to remove the grand total and keep subtotals?

@v-chuncz-msft ah, the latest version...

Thank you Microsoft 🙂

Highlighted
Frequent Visitor

Re: Matrix - How to remove the grand total and keep subtotals?

I have version Version: 2.71.5523.941 64-bit (juli 2019) (Desktop) but cannot find it.

Where exactly do i find it?

Highlighted
Frequent Visitor

Re: Matrix - How to remove the grand total and keep subtotals?

Sorry - found it! (but it looked different)

Highlighted
Advocate I
Advocate I

Re: Matrix - How to remove the grand total and keep subtotals?

For the Matrix Format (roller icon) there is not much functionality under the Grand Total property yet unfortunately.

I changed the Font Colour to white to make the grand total figure disappear, good enough till this is enhanced 🙂

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors