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!Get Fabric certified for FREE! Don't miss your chance! Learn more
Add a feature under the Matrix Visual's Column Grand Total that may be toggled to include additional Grand Total summary options aside from just the SUM it performs naturally. This way beyond just have a grand total column you can also include a % of the grand/sub total column. This proves especially useful when using a calendar table to populate months across a matrix as each column isn't it's own measure so it's not simple to just add an extra measure to the end of the matrix.
Currently if a matrix is created each row can only be summarized in one manner. If you wanted to also include each row's % of the Grand Total (or Sub Total), a new measure would need to be written and included in an additional matrix and hidden behind which can cause potential formatting issues down the road. Another option would be to right many-many dynamic measures to
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.