Forum Discussion
Helper Isort doesn't work well on non-alphabetic text fields
When you choose a sort field that is not in the report, it ignores that sort, even if it chose it as default. You can't force it to accept sort order from query - it seems to choose it's own random way of sorting. And because there is no manual row sort either you have to resort to some ugly workarounds.
Our use case: we have a count by day of week. We set up a code so that we can properly sort those in query, but when data is displayed it is totally random order. In tabular form we can add the code and sort (ugly but workable) but when we do some visualization the "code" makes no sense so there seems to be absolutely no way to properly sort (even thought the code field is chosen as the sort key in the data modeling). We have same proble with Seasons and all kinds of similar fields where alphabetic sort is NOT correct even though the field is text.
Any ideas out there?
- Hi there - we have a feature called 'Sort By' that should be able to help you here, for example making weekdays or month names appear in the right order in visuals. More details on that here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/ Hope that helps you!
5 Replies
- WillT
Community Admin
Hi there - we have a feature called 'Sort By' that should be able to help you here, for example making weekdays or month names appear in the right order in visuals. More details on that here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/ Hope that helps you!- aront
Thanks. Worked perfectly and solved my problem. I had already had a numeric index field to use to get it to sort the way I wanted. I was temporarily using that as the axis label. This is so much better! :)
SNikI have the same issue but its age banding and i am using a Slicer,
I have ...
Age AgeBand
1 [1-10]
2 [1-10]
3 [1-10]
.
.
22 [21-30]
23 [21-30]
.
.
and i am only using a Slicer and only displaying the [AgeBand] field , and i have sorted by [Age] and etc... but the [AgeBand] is not sorting correctly in the slicer.
the link doesn't work for slicers, any suggestion?
