cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
TheG
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
Sean
Community Champion
Community Champion

3 REPLIES 3
Sean
Community Champion
Community Champion

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

TheG
Frequent Visitor

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

 

 

 

Sean
Community Champion
Community Champion

@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...

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors