Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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?

 

 

Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    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).

     

1 Reply

  • Nolock's avatar
    Nolock
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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).