Custom sorting in a matrix table.

[Anonymous]

Hello,

Is there a way of sorting subcategory /2,3 and more cascades/ in a matrix table? Now I can sort first cascade or category names by SORT by Column method.

Subcategory is automatically sorted by alphabetically. Need help, thank you.

[Anonymous]

Hi, maybe not exactly but this solution worked for me, It allows sorting using RANKX function on main categories, I'm sure it can work with subcategories as well

https://alintelligence.tech/sort-matrix-by-selected-columns-with-rankx/

[amitchandak]

@Anonymous , Matrix does have multi -sort option as of now. So if sort on the category it should sort on the sub-category also . If sort on values all category and subcategory should sort based on the value

[Anonymous]

Thanks for reply. But I couldn't find any sorting options on matrix. Where I can find it? SS or path needed. Thank you.

[amitchandak]

@Anonymous , on click on the column name it should sort. There is option three ... dots .

If you created a pivot using column/s, then it sort column total not on the measure or on row columns

[Anonymous]

This is not what I am looking for. I mean

There are 3 categories. Each category has subcategories.  For example first A category has A,B,C,D subcategories.

I want it sort C,B,D,A. not by value or alphabetic. Full custom. C's value may be greater or less than B's value. It doesn't matter. I want see C's value on top. Thank you. 

[amitchandak · Accepted solution]

@Anonymous , Create a sort column

subcategories 1 = subcategories

sort subcategories=

switch([subcategories],

"C",1,

"B",2,

"D",3,

"A",4,5)

or like

switch( true() ,

[subcategories] ="C",1,

[subcategories] ="B",2,

[subcategories] ="D",3,

[subcategories] ="A",4,5)

and mark "sort subcategories" as sort column subcategories 1 and use subcategories 1 in viusal

refer steps

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column