how to put "other" at the end in a card

[NourJ]

Dear all, is there a way to keep the alphabet order in a card + put other at the end?

kindly note that my data have a monthly update and I cannot do it manually since I have more than 80,000 raws.

ex:

Apple

Banana

Orange

Other

thank you in advance

[PattemManohar · Accepted solution]

@NourJ Please try this as a "New Table" and use this in your visual

Test98Out = 
VAR _tmp = DATATABLE("Dummy",STRING,{{"Other"}})
RETURN UNION(SELECTCOLUMNS(Test98Append,"Data",[Data]),_tmp) 

[Anonymous · Accepted solution]

Hi @NourJ,

Step 1: Created Duplicate Column of which you want to sort suppose(i.e: Fruits_New)

Step 2: Created Another Calculated column (i.e: Sort Order) With Dax Formula Switch(table[Fruits],"Others","ZZZZ",table[Fruits])

Step 3: Drag Fruits_new Column to your Visual and sort by Step2 . i.e: Sortorder

you can also refer solved file for this here:

https://drive.google.com/file/d/1OzD9XfY89oJ5xs0lSjmuYc3jh5UOuhES/view?usp=sharing

Best Regards,

Ravi

[PattemManohar · Accepted solution]

@NourJ Please try this as a "New Table" and use this in your visual

Test98Out = 
VAR _tmp = DATATABLE("Dummy",STRING,{{"Other"}})
RETURN UNION(SELECTCOLUMNS(Test98Append,"Data",[Data]),_tmp)