Forum Discussion
Filter Date Ordering
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
4 Replies
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 moreHi 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