how get Grand Total on Matrix Visualization without the row totals

[Rahulsingh]

Hi Everyone

I am trying to get the Grand total without the row totals on a matrix visualization but i dont know how to achieve the result , when i select the row total it gives me total for every row. Any suggestions would be great.

Thanks

[Anonymous]

Hi Please refer to this blog :

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=e3eace80-...

I had same requirement and it worked for me , the solution in of second reply on thread. Cheers 🙂

[Sean]

@Rahulsingh

Select the Matrix => click the Format button (paint brush) => select On/Off

EDIT: Actually you have to convert the Matrix to a Table. We don't have a way to show only Grand Total and no Subtotals.

[Rahulsingh]

Then my question rises that how can i convert rows into column easily witthout using matrix visualzation.

[Sean]

So what happens when you click the Table button (to the left of the Matrix button) in the Visualizations

Don't you get what you wanted?

[Rahulsingh]

No because the columns in Matrix visualization are the values from a column in a table

[Sean]

Can you post a screenshot of what happens when you convert from Matrix to Table?

[Rahulsingh]

Here is the screenshot values inside the Trackingid column needs to columns and that is why i was using matrix but now i am stuck .

[Sean]

@Rahulsingh

This may not work for you - but how many JobAccount_TrackingIDs do you have?

Create that many tables => for each one Open in the Filters area and select only one at a time

You can also create Measures to SUM the hours for each JobTracking_ID...

003210-21010 Hours = CALCULATE(SUM(TableName[Hours]), TableName[JobAccount_TrackingID]="003210-21010")

But you'll have to create Measures for all IDs and then they'll show up as you want

Just place all Measures in the table => then each column will be a measure for the [hours] of that specifc Tracking_ID 

[Rahulsingh]

i have more that 300 traicking id's i dont think its going to work for me

[Sean]

The Matrix needs improvements I know... I added this idea last August...

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

Matrix is still not close to a good old fashioned Pivot Table - where you have total contol including NO Subtotals

That's why I still have to use Excel for some reporting...

[Rahulsingh]

Hi

I have this feature On but i am also getting row total which i don't need , i just want a grand total.

[Sean]

@Rahulsingh

Yes I realized after I posted you want Grand Total but no Subtotals - although easy in Excel we don't have this option in PBI for the Matrix.

So Convert your Matrix into a Table!

It looks like it will work in you case from the screenshot you've posted