New October Date Slicer still cannot sort month names correctly on Charts

[figo12]

Hi, the new October Date Slicer is great but it cannot sort month names correctly on Charts if they are filtered as "monthly", month names appear in the incorrect order, is there a way to fix this?

I know the trick for fixing the issue if there are month columns on the data, but in this case I have only one date value (mm/dd/yyyy), not sure how to apply the fix.

Thanks very much!

[BhaveshPatel · Accepted solution]

Create a new column by right clicking your table and use the below DAX Formula

MonthNo. = MONTH(YourTable[Date])

Followed by this, Select the Month Name Column in the Datatab View, Go to the Modelling Tab and Choose Sort by Column, Select MonthNo..

This will sort your month  names by the month no. . FYI- Default sorting is A-Z which makes month names sorting alphabetically.

See the screenshot.

SORT BY COLUMN

[BhaveshPatel]

Hi @figo12

Sorting a month requires you to use "sort by Column Feature" to sort it correctly.

You can create a new month column in the data using DAX.

[figo12]

Thanks @BhaveshPatel, you mean the month column and also and ID number Column for each month?  Have not used the DAX solution before, if you have some steps it would be great. Thanks again!

[BhaveshPatel · Accepted solution]

Create a new column by right clicking your table and use the below DAX Formula

MonthNo. = MONTH(YourTable[Date])

Followed by this, Select the Month Name Column in the Datatab View, Go to the Modelling Tab and Choose Sort by Column, Select MonthNo..

This will sort your month  names by the month no. . FYI- Default sorting is A-Z which makes month names sorting alphabetically.

See the screenshot.

SORT BY COLUMN

[walterosLP]

Hi there,

I am running in the same issue on PowerBI [November update], trying to sort month in a Slicer, drop-down list and even Weekdays from the same table.

However, even I did sort them correctly, non of both lists does any sort at the report view and show it in a list by random.

What can be wrong?

[figo12]

Thanks!! @BhaveshPatel I will give it a try!

[figo12 · Accepted solution]

It worked great!!! Thanks very much  @BhaveshPatel