I'm creating a pivot table by connecting to an SSAS tabular model (Data -> From Other Sources -> From Analysis Services) .
The model has a "time" column that I want to sort by. The default (database) sorting is earliest to latest:
When I click the triangle next to 'Row Labels' and select "Sort A to Z", I get alphabetically sorted times:
How can I get the times to sort by time? Changing the number format from "General" to "Time" does nothing. The times aren't stored as text either - the data type of the column in the SSAS model is