Forum Discussion
multi-column matrix sorting
hi,
i have matrix visualization with multiple columns which are both measures & dimensions as follows:
. yearmonth (dimension)
. organization name (dimension)
. total income (measure)
i'd appreciate any help on how to do multi-column sorting in matrix, if it's possible.
tks & krgds, -nik
I want to do a multiple column sort (like in Excel) first on Budget then on Project_duration in Power BI.
For Year and Organization, you have a combine column and sort, But that might not look good in the matrix
New column
Year Org = [Year] & " " & [Organization]
But ideally, they should in some sort order by default
5 Replies
Anonymous ,
I think that got supported for the table in march 2020 release, please explore here
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/
With control and click you can sort on another column
thanks for your quick response, amitchandak.
yes, i have got it working for tables visual. however, i need it to be done for matrix visual which don't seem to be able to have multi-column sorting.
i'm considering dax too if it's possible in matrix visual.
krgds, -nik-
For Year and Organization, you have a combine column and sort, But that might not look good in the matrix
New column
Year Org = [Year] & " " & [Organization]
But ideally, they should in some sort order by default