Forum Discussion
Filter Date Ordering
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:
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
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
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:Thanks for the help Anonymous! This resulted in the outcome I was looking for.