Date Sort

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

this worked perfectly. Thank you so much

[Anonymous · Accepted solution]

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

[Anonymous]

the date format on the visual is what the stakeholder wants.. 😞