Skip to main content
Microsoft Idea

Power BI

Needs Votes

sort order ascending first

Vote (12) Share
Mike's profile image

Mike on 17 May 2016 07:27:58

Sorting tables
If my table is sorted by Sales$ and I click "Customer" then my table is sorted by Customer DESCENDING I have to click Customer again to get ascending. I'd like that to be switched so ascending is first.

Comments (1)
Mike's profile image Profile Picture

Matt Allington on 05 Jul 2020 23:49:23

RE: sort order ascending first

I agree with this. When the data is numeric, then sort descending is very useful. When you use categorical data, it should be ascending. There is also an issue when you first set a numeric column (say Month Number of Year) as an axis in a chart. Initially it is set to continuous descending (this is OK), but when you switch it to categorical then the sort order should automatically change to ascending. It makes no sense for the default of a categorical axis to sort descending by default.