I have Timing Order but Chart is getting sort by value

[mohamedm]

Dear All,

i have timing_hour

00-01

01-02

02-03

the data values, when i add this to chart order based on value hight value coming first , i want to make timing order anyway i can do ?

chart should 00-01 , 01-02 etc..

[Uzi2019 · Accepted solution]

Hi @mohamedm 

Try to sort then chart by time value column.

sort by time value instead of numeric value.

Click on 3 dots of your chart > sort by select field name > Asc/desc

I hope I answered your question!

[mohamedm]

Thanks it worked.. 

[bhanu_gautam]

@mohamedm You can create a calculated column that extracts the hour part of your timing_hour values.

SortOrder = VALUE(LEFT([timing_hour], 2))

After creating the SortOrder column, go back to the "Data" view.
Select the timing_hour column.
In the "Column tools" menu, click on "Sort by Column" and choose the SortOrder column.