The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to 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.
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")
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.
Thanks for the help, It worked perfectly !!!
Regards