Sort "MMM-YY" in monthly order for slicer

[nuhasan]

Hi all,

How do I sort my date below "MMM-YY" in monthly order for slicer?

Step I already try:

1. Sort axis - Month Year

Regards,

Nuha

[v-kkf-msft · Accepted solution]

Hi @nuhasan ,

If you have a date column, then add the following new column, and sort [Month Year] column by [YearMonthNum] column.

YearMonthNum = FORMAT ( [Date], "yyyymm" )

For more information, please refer to: Sort one column by another column in Power BI 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jostnachs]

Its giving me the following error

[Sharuko7]

Thank you

[nuhasan]

Understood and thanks!!

[wdx223_Daniel]

add a new column of YearMonthNumber, then Sort By Column

[nuhasan]

Hi @wdx223_Daniel ,

What do you mean YearMonthNumber? Can you provide some example?

Regards,

Nuha

[AlexisOlson]

These prior posts may help:

https://community.powerbi.com/t5/Desktop/Sort-Month-and-Year-in-Chronological-order/m-p/957680

https://community.powerbi.com/t5/Desktop/sorting-a-date-table-chronologically/td-p/280635