Sort Column Order in Matrix

[TomSinAA]

I am trying to sort the column order of a matrix.  I created a helper column to use as the sort order.  But when I click the field for the columns in the matrix and click sort by the helper column I get an error message

[Samarth_18]

Hi @TomSinAA ,

Could you please share the code that you have written for sorting?

And please provide some sample data with the expected output it help us to give you a more specific answer

[TomSinAA]

Hi @Samarth_18 ,

I created a new column in my table using this formula:

StateSort = Switch(TMSShipmentDetail[State],"Awaiting", "1","Tendered", "2", "Confirmed", "3", "Pick Ready", "4", "Intransit", "5", "Delivery Ready", "6", "Received", "7").   Then clicked the State field in the right panel, then selected Sort column by and selected: StateSort.  It displayed this error: 

[Samarth_18 · Accepted solution]

Hi @TomSinAA ,

you could try this code:-

StateSort = SWITCH(
    TMSShipmentDetail[State],
    "Awaiting", "1",
    "Tendered", "2",
    "Confirmed", "3",
    "Pick Ready", "4",
    "Intransit", "5",
    "Delivery Ready", "6",
    "Received", "7",
    "0"  // Default value in case none of the above conditions are met
)