Forum Discussion
Sorting Calculated Column
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.
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.
3 Replies
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.
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")
