How to arrange the time group in ascending order

[Andrew_na_lang]

Hi Fam,

I have made groups and wanted to know if there is a better way of arranging the groups in ascending order. 

It should start from

1-5 minutes
5-15 minutes
_
_
_
_
6days to 7days
More than 7 days. 

 

[OwenAuger · Accepted solution]

Hi @Andrew_na_lang 

The usual way to do this is to create an additional column in the same table to act as a "sort by" column (documentation page).

This new column would typically be an index of some sort, corresponding to the sort order.

Each value of the existing column must map to a single value in the "sort by" column.

Note that the "sort by" column cannot be a DAX calculated column that references the original column, as this creates a circular dependency (due to the inner workings of this feature).

e.g.

Sign-up to First Order Time breakdown	Sort
1-5 minutes	1
5-15 minutes	2
...	...

Once created, select the original column > Column Tools > Sort by column > select the new column.

Regards,

Owen