I am trying to use a matrix to display products in the first column (row labels) and cities as column headers across the top. Revenue will be in the table. I would like to sort the row totals descending (largest revenue product on the top and smallest revenue product on the botom). I would like to also sort the city column totals in the bottom row descending (largest city on the left and smallest city by revenue to the right). I can do this in a pivot table in excel, but can not figure out how to sort both columns and rows descending based on the totals in Power BI.
I have tried other ideas in other forum posts, but nothing seems to allow for multiple sorting in a matrix. I also need the order to be dynamic as different filters will change the order of the rows and columns
Please advise with any solutions/ideas on how to sort by row and column in the matrix or if another visualization will provide this result.
