To sort fields in the Matrix Visual: Fields Icon > Drag individual fields to Rows
Turn on Subtototals (optional): Format Roller > Row subtotals > Apply to labels (On) > Per Row Level (On) > Choose On for field(s) to be included in Subtotal
What would you recommend in the cases where a matrix won't work? In other words, when I have data that I do not wish to summarize in any way, a matrix is impossible to use.
is multiple sorting in a matrix possible without using dax workaround?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!