Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Is there a way to have the grand total in a matrix visual show while the matrix is expanded to the lowest level? Below is an example of how my matrix is set up, but I want the grand total to show at the bottom. It shows when not expanded for just the grand total, but when expanded it disappears. I'd like it to show with the grand tota for the groupings as well
Product Group1 Product Group2 Product Group 3
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523