RL1Frequent Visitor9 years agoNatural sort order for text Is there a simple way to sort data in a natural order in PowerBI? i.e. being able to sort a text column to be ordered as: A1, A2, A10, A11, A12, A20, A21 instead of: A1, A10, A11, A12...Show More
dataXAdvocate I9 years agoRL1 As a workaround you can edit query. Split column by number of characters, use 1 left split , get a new numerical column and sort on that. Hope it helps!!
Related contentTable Sort , sort order , comparerSort Order issuesorting months in orderPBI app audiences sorting/orderingField Parameters sort order
