Forum Discussion
multi-column matrix sorting
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
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