cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dsandip59 Member
Member

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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

Hi @dsandip59,

 

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

 

Capture3.PNG

View solution in original post

1 REPLY 1
Super User II
Super User II

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

Hi @dsandip59,

 

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

 

Capture3.PNG

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors