Forum Discussion
Sorting by Date (M/D/YYYY)
Hi I want to sort the services by date (M/D/YYYY). I have a separate date table & a date column in my core excel data file. But I can not sort them by date. Sending you the screen sort of the files...
Hi Anonymous,
Based on my test, it could work on my side.
Sample data and relationship
Create a visual and modify the format in X-Axis from continous to categorical and you can see the result.
I would suggest you test again. Also you can test with our sample report on your side to see if the same issue occurs.
https://www.dropbox.com/s/90hcs87p23287m2/Sorting%20by%20Date%20%28M%20D%20YYYY%29.pbix?dl=0
Regards,
Danile He
Select your day column and see if the colum type is date. If not, change it to date, the issue should be fixed.
MFelix
Super User
Super UserHi Anonymous,
Why don't you use the Date column on your Dates tables on your chart instead of this column? It should give you the order you need.
Regards,
MFelix