How to sort the date slicer according to the calendar order?

[Anonymous]

Hi,

I added date slicer but its getting sorted according to ascending order (i.e April 2019,April 2020, August 2019, August 2020...). How can I sort this to the calendar order?

I already try creating a separate table for month and numbering months 1,2,3... But when I am trying to merge the two tables through merge queries. Im getting an error.

Note: My date column type is "text" not "date" because I can't keep the text format if change it to "date"

Thank you in advance

[ImkeF · Accepted solution]

Hi @Anonymous 

No need to merge, just use the sort-by-column feature: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column