Forum Discussion
Solved
Date Sorting in Line Chart
Evening All (well in the UK!), After some assistance with a line chart, I'm struggling to get the sort order I want to acheive. I understand that I could add columns and sort on those but not sur...
Tucker,
Do you have year field and MonthName field in your table? You can drag the two fields to X-Axis of Line chart, then sort by YearMonth, for more details, please review the example in the video below.
https://1drv.ms/u/s!AhsotbnGu1Nok2Hf0nL18Zx_T3m1
Regards,
Lydia
Tucker,
Do you have year field and MonthName field in your table? You can drag the two fields to X-Axis of Line chart, then sort by YearMonth, for more details, please review the example in the video below.
https://1drv.ms/u/s!AhsotbnGu1Nok2Hf0nL18Zx_T3m1
Regards,
Lydia
Thanks Lydia, Anonymous
Perfect, had to do a slight tweak by adding the Year, Month and MonthName with a triple sort but works exactly as required thanks must have been having a senior moment!!