Forum Discussion
Solved
How Do I Avoid Alphabetical Sorting?
Hi All, Total BI Newbie here. I have a list of costs being fed into my report, and it auto-sorted to alphabetical. I want it to show as its native sorting. How do I control this? The arrow on the...
You need a numeric or alphabetic column that corresponds to that original sort order, then use that to sort.
I find it hard to belive that PBI will have such a counterintuitive (and, under some circumstances, outright stupid) "feature" as a non-preventable sorting. So if I have a table where the first column is presented in some logical order (say, animals by ascending size - dog, horse, elephant), there is no way to preserve that order without resorting to all sorts of unnecessary gymnastics?
Is there really no way to prevent it?