This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.