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.
"The order in which Power BI receives it" would be an arbitrary order unique to any given query or refresh. It would essentially be completely random. So that wouldn't help you.
I have the data sorted in the query behind the visual - on multiple columns - so that's the order I want to see in the table as well. Not the default behaviour which is to have the Table visual automatically sort the data for me automatically in ascending order on the first column. Please add the "don't sort" option to the Table visual.