Reply
Member
Posts: 57
Registered: ‎03-13-2018
Accepted Solution

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.

Sorting Date.PNG

 

 

Thanks,

spanda


Accepted Solutions
Community Support Team
Posts: 1,549
Registered: ‎06-24-2018

Re: Sorting by Date (M/D/YYYY)

Hi @Panda2018,

Based on my test, it could work on my side.

Sample data and relationship

1.PNG

Create a visual and modify the format in X-Axis from continous to categorical and you can see the result.

2.PNG

 

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

View solution in original post

Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

Re: Sorting by Date (M/D/YYYY)

Select your day column and see if the colum type is date. If not, change it to date, the issue should be fixed.

2018-08-17_10-53-30.png

 

 

 

View solution in original post


All Replies
Super User
Posts: 2,041
Registered: ‎09-19-2016

Re: Sorting by Date (M/D/YYYY)

Hi @Panda2018,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Community Support Team
Posts: 1,549
Registered: ‎06-24-2018

Re: Sorting by Date (M/D/YYYY)

Hi @Panda2018,

Based on my test, it could work on my side.

Sample data and relationship

1.PNG

Create a visual and modify the format in X-Axis from continous to categorical and you can see the result.

2.PNG

 

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

Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

Re: Sorting by Date (M/D/YYYY)

Select your day column and see if the colum type is date. If not, change it to date, the issue should be fixed.

2018-08-17_10-53-30.png

 

 

 

Member
Posts: 57
Registered: ‎03-13-2018

Re: Sorting by Date (M/D/YYYY)

Thank you @v-danhe-msft so much !! It worked Smiley Happy

Member
Posts: 57
Registered: ‎03-13-2018

Re: Sorting by Date (M/D/YYYY)

Thank you so much!! @Jessica_Seiya..I fixed this too...It worked!! Smiley Happy

 

Thanks!!