Sorting Calculated Column

[Anonymous]

Hi All,

Is there a way to sort the legends here in the below order:

<10K , $10K-50K , $50K-100K, >$100K 

P.s : I have created the calculated column for this visual.

[Ahmedx]

write the measure like this

ARR Bands =
SWITCH(TRUE(),
VW_PBI_ARR_ACCOUNT[LOGO_PLAN_ARR] < 10000,REPT(UNICHAR(8203),4)&"<$10K",
VW_PBI_ARR_ACCOUNT[LOGO_PLAN_ARR] >= 10000 && VW_PBI_ARR_ACCOUNT[LOGO_PLAN_ARR] < 49999.99,REPT(UNICHAR(8203),3)&"$10K-50K",
VW_PBI_ARR_ACCOUNT[LOGO_PLAN_ARR] >= 49999.99 && VW_PBI_ARR_ACCOUNT[LOGOPLANARR] <= 99999.99,REPT(UNICHAR(8203),2)&"$50K-100K
VW_PBI_ARR_ACCOUNT[LOGO_PLAN_ARR] >= 100000,REPT(UNICHAR(8203),1)&">$100K")

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to achieve this is creating a new column for the sorting purpose.

ARR bands sort CC =
SWITCH (
    TRUE (),
    tablename[columnname] < 10000, 1,
    tablename[columnname] >= 10000
        && tablename[columnname] < 49999.99, 2,
    tablename[columnname] >= 49999.99
        && tablename[columnname] < 99999.99, 3,
    tablename[columnname] >= 100000, 4
)

Try to create one more calculated column like above, and sort the  [ARR bands] column by the above column.

Thanks.

[Anonymous]

Thanks for the help, It worked perfectly !!!

Regards