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