Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

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.

Let me know if you need more explanation.

Thanks,

spanda

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.

5 Replies

v-danhe-msft
Microsoft Employee
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
  Not applicable
  8 years ago
  Thank you v-danhe-msft so much !! It worked :)
Anonymous
Not applicable
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.
- Anonymous
  Not applicable
  8 years ago
  Thank you so much!! Anonymous..I fixed this too...It worked!! :)
  
  Thanks!!
MFelix
Super User
8 years ago
Hi 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

Related content