Forum Discussion
How to order dates chronologically on graph x-axis
Hi cmccarra,
Based on my test, you can refer to below steps:
1.Create a Clustered column chart and add the [month] and [avg] fields.
2.Put the [year] field before the [month] and use the “Expand all down one level in the hierarchy” function in the visual. Now you can see the correct result.
Regards,
Daniel He
Microsoft EmployeeHi cmccarra,
Based on my test, you can refer to below steps:
1.Create a Clustered column chart and add the [month] and [avg] fields.
2.Put the [year] field before the [month] and use the “Expand all down one level in the hierarchy” function in the visual. Now you can see the correct result.
Regards,
Daniel He
Hi v-danhe-msft, thanks for your reply. I tried what you described before but I still ended up with the graph starting at Jan-2018. I followed your guide and this happended again but I then clicked on the 'Sort By YearSent MonthSent' option from the visual dropdown menu twice and got the desired results. The sort by option seems a bit temperamental, it took a few clicks on some graphs to get it sort correctly.
Thanks for your help!