Month Sort Order Filter

Power BI Data Model
1

Hi Everyone,

I have a question regarding the month sort order.

I am currently using the dates table function as supplied by Sam and this works great.

The issue i have is that when getting the month names, it sorts it alphabetically (See Screenshot)

I have attempted to go to the table and select the month name column and sort it by date. I then get an error as the month name does not have unique values.

What is best practice around this? Switch Statement or perhaps creating a table with all the month names in 1 column and then adding a numerical value to to sort in that order?

Thanks in advance.

image

image

2

You sorting by the incorrect column. You need to sort by MonthnYear (based on the date table code provided)

1 Like
3

Thank You.

That worked out well.

1 Like