Sort hierarchy members in the dimension editor

You can choose from several sort orders to sort hierarchy members in the dimension editor.

Click the Sort members icon Sort members icon in the toolbar to access the sort options.

Sort options in the dimension editor

The following sort options are available:

Ascending
Sort members in ascending order.
Descending
Sort members in descending order.
Hierarchize
Organize the members of specified set into hierarchical order.
Hierarchically ascending
Sort members within a hierarchy in ascending order.
Hierarchically descending
Sort members within a hierarchy in descending order.

For more information, see Welcome to the new experience dimension editor.