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...
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
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
Yes