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...

Need Help

v-danhe-msft
8 years ago
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
Anonymous
8 years ago
Select your day column and see if the colum type is date. If not, change it to date, the issue should be fixed.