Forum Discussion
How Do I Avoid Alphabetical Sorting?
You need a numeric or alphabetic column that corresponds to that original sort order, then use that to sort.
Thanks Charlie.
This would work if I want it to sort by a certain column. But how do I get it to NOT sort. We have a specific order the original file is in, and we want it to show up that way, which is non-alphabetical nor numerical.
You need a numeric or alphabetic column that corresponds to that original sort order, then use that to sort.
I am no database expert but that seems like a major oversight to me... Wouldn't all programs start withOUT modification to the list, then allow users to modify the list with features? Odd. But I can do that... Thanks!
No, I wouldn't expect that. The only natural sort orders are alphanumeric or date. Any other order would need to be specified by some other piece of data, such as a row index number. A row index number would be a column in a database. If you don't have a column that corresponds to that piece of data, you don't have that sort order.
I have the same problem... I am trying to display text in a multi-row card or a table or a matrix or anything. Power BI sorts my data alphabetically. I do not want it sorted. So I added a sortby column. However, I cannot hide this sort column from the user.
I sorted the data in the data view. But when I add it to a multi-row card or table PowerBi sorts it for me.
