cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TheG Frequent Visitor
Frequent Visitor

MATRIX COLUMN GRAND TOTALS IS IT POSSIBLE WITH THIS VISUALIZATION

Hi Community,

I recently started using PBI and I came accross a problem which i cant work out and perhaps is a limitation of this Visulation i am using or my lack of experience with this product.....hopefully its the latter.

 

I am using the Matrix Visulation to break up costs in the general ledger accounts by job. I need a Grand total at the bottom to show the total costs allocated to this job.

 

Is this possible ? or is there a better way to do this report?

 

PBI.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: MATRIX COLUMN GRAND TOTALS IS IT POSSIBLE WITH THIS VISUALIZATION

@TheG Yep this is not currently possible! Look at my answer here...

 

http://community.powerbi.com/t5/Desktop/how-get-Grand-Total-on-Matrix-Visualization-without-the-row/...

 

You can Vote here (I created this Idea in August 2015)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

You can also post comments here (where they seem to have consolicated all main Matrix Ideas)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdo...

3 REPLIES 3
Super User
Super User

Re: MATRIX COLUMN GRAND TOTALS IS IT POSSIBLE WITH THIS VISUALIZATION

In the Format (Paint Brush) for the Matrix => General => Total Row => ON

TheG Frequent Visitor
Frequent Visitor

Re: MATRIX COLUMN GRAND TOTALS IS IT POSSIBLE WITH THIS VISUALIZATION

Hi@Sean

 

Thanks so much for the reply this however gives me a subtotal per Account if i put the row total on....not really whats required.

 

I need a GRAND TOTAL only at bottom of column for each Job. ie $125,788.98 + $41,813 = $167,601.98 for D1 etc

 

It seems others have had this issue where you cannot turn off the subtotals on the columns and only have a grand total at bottom.

 

I can do this in Excel without a problem it seems a little more intelligent when it comes to this table formatting...

 

PBI3.PNG

 

 

 

Super User
Super User

Re: MATRIX COLUMN GRAND TOTALS IS IT POSSIBLE WITH THIS VISUALIZATION

@TheG Yep this is not currently possible! Look at my answer here...

 

http://community.powerbi.com/t5/Desktop/how-get-Grand-Total-on-Matrix-Visualization-without-the-row/...

 

You can Vote here (I created this Idea in August 2015)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

You can also post comments here (where they seem to have consolicated all main Matrix Ideas)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdo...