Forum Discussion

UrbanCK's avatar
UrbanCK
New Member
6 months ago
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 "...
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    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

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
6 months ago

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