Forum Discussion
Custom sorting in a matrix table.
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 , 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
6 Replies
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 , 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
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/