Forum Discussion
Solved
How to customise sorting range values in Matrix?
Need help with how to create a DAX measure to custom sort below in Matrix table: The PO Range Value for "$5,001-$10,000" needs to be after "$1,001-$5,000" and '$50,001-$250,000" needs to be before "...
Create a sort order calculated column in the same table:
PO Range Sort = SWITCH ( TRUE (), 'Purchase Orders and Items'[Total Order Value] <= 1000, 1, 'Purchase Orders and Items'[Total Order Value] <= 5000, 2, 'Purchase Orders and Items'[Total Order Value] <= 10000, 3, 'Purchase Orders and Items'[Total Order Value] <= 25000, 4, 'Purchase Orders and Items'[Total Order Value] <= 50000, 5, 'Purchase Orders and Items'[Total Order Value] <= 250000, 6, 'Purchase Orders and Items'[Total Order Value] <= 1000000, 7, 8 )Then apply Sort by Column:
Select the PO Range Value column → Column tools → Sort by Column → PO Range Sort
Hello UrbanCK ,
Here are the steps :
1. Create a new table using enter data .
| ID | Range |
| 1 | $0-$1000 |
| 2 | $1001-$5000 |
| 3 | $5001-$10000 |
| 4 | $10001-$25000 |
2. Sort Range by ID ( select field Range, use toolbar ro sort by option, sort by ID)
3. Create relationship between this table and your original table using range.
4. Use Range from this table to your visual and you are done.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps, kudos are appreciated.
Cheers.