Forum Discussion
Helper IIIDates not sorting correctly on line graph
hi, thampton
If i use the 3 dots, it is still out of order as it is sorting alphabetically. I need it to sort in chronological order.
The data type of the field should be text instead of date.
Please check select that field then Modeling->Formatting if it is a date field.
and you could also use Sort by column in Power BI Desktop.
If not your case, please share the sample pbix file. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Helper IIIAnonymous It is a date field that i am using as the x axis on a ling chart.
If i use the 3 dots, it is still out of order as it is sorting alphabetically. I need it to sort in chronological order.
Community Supporthi, thampton
If i use the 3 dots, it is still out of order as it is sorting alphabetically. I need it to sort in chronological order.
The data type of the field should be text instead of date.
Please check select that field then Modeling->Formatting if it is a date field.
and you could also use Sort by column in Power BI Desktop.
If not your case, please share the sample pbix file. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin