Sorting dates in a slicer

[U156531]

I need to be able to sort these dates by month in the slicer. There is n't any column in the Sort By Column list that works to sort these.

[AnkitaaMishra]

Hi @U156531 , Hope you are doing well.
I tried to replicate your problem considering that you have a date column in your table, please write below DAX to create another column : 

Now select the "Month selection" column and use "Sorting" column to sort it as shown below : 

Output : 

if this helps please mark it as the solution else provide additional details for your problem.

Thanks,

Ankita

[U156531]

I'm getting this syntax error trying to create the new calculated column

My year calcualted column is 

[AnkitaaMishra]

@U156531 please write below formula : 

Sorting =

VAR DateYear = VALUE(LEFT('Date'[Year], 4))

VAR DateMonth = MONTH(DATEVALUE('Date'[Month Number] & " 1"))

RETURN DateYear * 100 + DateMonth

Please replace the table and column name according to your table. 

You are getting an error because you are creating a VARIABLE but not returning the output.

[U156531]

That fixed the error in the calculated column.

I'm sorting the MTD by the new calculated column Sorting.

Unfortunately it didn't seem to sort it correctly.

my calendar table is below

[Anonymous]

Hi @U156531, AnkitaaMishra and Selva-Salimi, thank you for your prompt reply!

From your screenshot, the new column is of Text type, please change to the whole number, then sort the MTD again.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[U156531]

Its a text field and I can't convert it to Date without getting this error below. Here is whats in the field.

[Selva-Salimi]

Hi @U156531 

Is your column in date format? I think not because if it was in Date format you can easily sort it.

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.