Forum Discussion
Matrix Column Sort Order
My apologies if the solution for this is already out there, I don't think it is but I figured it wouldn't hurt to check. I am using the matrix visual to compare year by year profitability of a ra...
For sorting matrix columns by a measure value (profit) rather than alphabetically, the cleanest approach is a Sort by Column on the product dimension:
- Create a calculated column: Product Profit Rank = RANKX(ALL('Products'), [Profit],, DESC)
- In Data view, select the Product column → Modeling tab → Sort by Column → select Product Profit Rank
- The matrix columns will now sort by profit descending
Limitation: this sort is static it ranks based on total profit across all years, not per-year profit. If you need dynamic sorting where column order changes when the user switches years in the slicer, that's not supported natively in the Matrix.
For dynamic column sorting that updates based on slicer selection, Flexa Tables on AppSource supports drag-to-reorder columns in the published report users sort columns themselves without going back to Desktop