Sorting Time Intelligence - want to sort Time values in drop down

[Anonymous]

Hi,

I have created a column using below DAX:

Hour = format(Data[FIRST_TOUCH_DATE_TIME], "hh:mm:ss AM/PM")

now I want to sort values as P.M Values will come at Upper side, so i will basically sort by Descending order. How can I achieve this?

[Nolock · Accepted solution]

Hi @Anonymous,

you have to create another column with the expected order and then tell your Hour column that it should be sorted by the newly created column (see the attached screenshot).