Unable to last sort 24 hours.

[Anonymous]

I want to show X-Axis with last 24 hours. If time now is 12 pm , then i have to show 12Pm now to 1 PM yesterday.

Problem here is when i am trying to sort in modeling, it throws error. because it has too many same values to sort.

Date                Hour      Min       Avg Time

4/1/19 10:00 AM	10	0	0.402727
4/1/19 9:59 AM	9	59	0.080909
4/1/19 9:59 AM	9	59	0.046
4/1/19 9:58 AM	9	58	0.065384
4/1/19 9:59 AM	9	58	0.07

4/1/19 9:58 AM	9	58	0.186666
4/1/19 9:57 AM	9	57	0.22
4/1/19 9:57 AM	9	57	0.077857
4/1/19 9:57 AM	9	57	0.197333

the graph is sorting like numbers from 0 to 23 or 23 to 0.

But i need like  17  18  19  20  21  23  0  1  2  3  4  5  6  7  

Thanks

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.

Regards,

[Anonymous]

It will always sort from 13 - 12 like 13 14 15 16 17 ------- 10 11 12

But i need according to current time. 

if time now 8m , Sort should be 8 7 6 5 4 3 2 1 0 23 22 21 20 --------- 12 11 10 9 .

---

@v-cherch-msft wrote:

Hi @Anonymous 

You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.

Regards,

---