Use the Sort transformation to arrange dimensions and measures in ascending or descending order.
Sorting data helps improve readability and ensures that query results appear in the order required for analysis and reporting.
The following example sorts the Market & Geography column in ascending order.
On the Transform tab, select Sort Ascending in the Sort group.
The Sort By Ascending dialog opens.
In Column Name, select Market & Geography.
In Order, select Ascending.
Select Apply.
After you apply the sort, the column appears in the order you specified.
In this example, the Market & Geography column appears in ascending order.
The applied sort appears in Performed Steps and applies to subsequent transformations, calculations, and reporting scenarios.
You can also sort data directly from a column menu without opening the Sort dialog.
Open the menu for the column to sort.
Select Sort ascending or Sort descending.
The column sorts immediately based on your selection.
Last updated 7 days ago
Was this helpful?
