Date Sort

Hi Anonymous ,

Generally speaking, if the data type of your calendar column is set to 'Date', the line chart will automatically sort by date. However, I assume your column is of the 'Text' type. I've conducted a test for your reference.

1\I assume there is a table

2\Add a new caculate column DateValue and set it's format to mmm dd

DateValue = DATEVALUE('Table'[DataColumn])

3\Using the new column DatValue as the x-axis

4\Set X-axis

Best Regards,

Bof

this worked perfectly. Thank you so much