cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
var_dby89 Frequent Visitor
Frequent Visitor

Sorting by Date (M/D/YYYY)

I am unable to sort date by year in slicer. The problem is when i am clicking on dropdown there date is showing month wise for both years 2017 and 2018 together. so i want the year 2017 should come first before year 2018.. Hope you understand my query 

 

 

Capture.PNG

Thank in advance

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

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

Check your data type, it's probably text rather than date

Super User
Super User

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

@var_dby89 If you want to retain the same format in the slicer (i.e. MMDDYYYY) then use the "Sort by Column" option to sort this field on the proper date format.

 

image.png



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

Proud to be a Datanaut !





2 REPLIES 2
Super User
Super User

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

Check your data type, it's probably text rather than date

Super User
Super User

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

@var_dby89 If you want to retain the same format in the slicer (i.e. MMDDYYYY) then use the "Sort by Column" option to sort this field on the proper date format.

 

image.png



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

Proud to be a Datanaut !