Forum Discussion
Analyse in Excel - Sort Order
I've noticed for the last few months at least that when I run reports in Analyse in Excel, the data source order isnt reflected. It sorts correctly in Power BI itself. Other users have also noticed t...
I do experience the exact same issue on a simple CALENDAR table and a column that rely on a numeric column for sorting in PBI. In PBI everything is working fine in EXCEL I have the below occurences:
| Default Datasource Sorting (Correctly sorted using the "sort" column set in PBI) | Ascending (Alphabetical instead of using "sort" column set in PBI) | Descending (Reverse alphabetical instead of using "sort" column set in PBI) |
|
|
In PBI: