Filter Date Ordering

[Anonymous]

Hi all,

I have a report where I use a (generated) date table which works fine but I have encountered a slight problem with the filtering. Filter Order

Refering to the picture above; The month names are shown in alphabetical order but I would like to achieve a order where it is shown in order of date (January; Februari; March; etc.).

I am not sure how this is done so any help would be greatly appreciated!

Best regards,

LMeijdam

[Anonymous]

Create a new calculated column using below dax, ensure that column datatype should be whole number.
After that sort your Month Name column using MonthID by using sort by column option under Modeling tab.

MonthID = FORMAT(Date,"MMYYYY")

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

[Anonymous]

Hi @Anonymous,

Thanks for your fast response!

I don't see how this will solve the issue, my dataset itself is already ordered by date. (see picture below)

The column I use in the filter "Month Name" and that is how I want the data in the filter to be formatted. I understand that I can order this table on your Dax Code but that will not affect the ordering of the filter I am afraid.

Best regards,

Lieuwe Meijdam

[Anonymous · Accepted solution]

Hi @Anonymous,

After creating your calculated column, you can find sortbycolumn option under modeling tab from there you need to sort your MonthName column based on MonthID. Please find the below screenshots FYR.
Before Sort:

Sort by MonthID:

After Sort:

[Anonymous]

Thanks for the help @Anonymous! This resulted in the outcome I was looking for.