Urgent... How to sort date for line chart x-axis.

[xiumi_hou]

Dear all,

I want my line chart date x-axis from the olddet to newest.. But now I do not know why it not in order.. .Can someone help me? Thanks

[v-lid-msft]

Hi @xiumi_hou ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft · Accepted solution]

Hi @xiumi_hou ,

Could you please check the data type of the column and the setting of "Sort By Column" ?

Also check the setting of "Sort By" in the chart.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

The Date on the X-axis of the chart should be dragged from the Calendar Table.

[xiumi_hou]

Hi Thanks for asking. Do you mean I can not use the date from my case day, I need to create a seperate calendar table? Thanks.

@Ashish_Mathur 

[Ashish_Mathur]

Yes, you need to create a Calendar Table and build a relationship from the Date column of your base data table to the Date column of your Calendar Table.

[xiumi_hou]

Hi @Ashish_Mathur ,

I dragged from the calendar table... The order still show wrong result. Do you have any suggestion? Thanks