Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
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!
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.
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?