Forum Discussion
Date Sort
Hi,
i have the below visual but i am unable to sort it by date. is it possible to sort it by date and how?
Thanks.
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
3 Replies
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