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.
Hi Anonymous,
That would greatly depend on the data source that you use. If you are using JSON for an examle, you might want to display the data in the exact order you received it as the data source might have already sorted it in a specific order that is not necessary chronologically or alpha-numerically sorted or sortable.