Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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/
@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
Thanks for reply. But I couldn't find any sorting options on matrix. Where I can find it? SS or path needed. Thank you.
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |