Forum Discussion
how get Grand Total on Matrix Visualization without the row totals
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
12 Replies
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.
Hi
I have this feature On but i am also getting row total which i don't need , i just want a grand total.
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
Then my question rises that how can i convert rows into column easily witthout using matrix visualzation.
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?
Hi Please refer to this blog :
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=e3eace80-82ad-4bba-853e-f8e7fcb60875&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
I had same requirement and it worked for me , the solution in of second reply on thread. Cheers 🙂
