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
Hi UrbanCK,
Please make sure you are creating a column and not a measure, PO range sort and Total Order Value are columns only. in the error it's indicating about the column "PO range Value 2", could you check if Total Order Value is dependent on it?
Kindly share the sample .pbix (remove confidential information or replace before sharing) if issue is not yet resolved after the fixes
