multi-column matrix sorting

[Anonymous]

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.

[amitchandak]

@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

[Anonymous]

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-

[amitchandak · Accepted solution]

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]

tks again, @amitchandak.

will that be by means of creating a calculated column?

krgds, -nik

[amitchandak]

Yes