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.
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.
You can add a sort order column based on one or more column s that you want to sort on. Add that column to the table in the report and sort by that column. You can shrink the size of that column so it is not showing. You cannot hide it but you can shrink it to nothing so it doesnt show anyway.