Forum Discussion
Creating a date column with only day and month
I need to create a Data filter that shows me the values between, for example 1/09 to 20/11, of many years (i.e. 2017-2018-2019) all based on that period. How can I do it? Is it possible to create a date column that does not take into consideration the year and only report the day and month ?
Thanks for helping me,
6 Replies
Another solution perhaps is to:
1. Put the date value (in date form not string) into the matrix/table/other visual
2. Select the measure/column in the fields pane
3. Under the format pane at the top of the page, you should be able to enter custom formats that will still interpret the date as a date rather than a string, however you can customise it more than the options shown on the drop down.
In this case if you wanted the day of the month and then the month name, e.g. 1 January, you would put in this format.
WillDrotarAdvocate I
Thank you for posting this. I don't know if this is a new feature, but this literally saves us in DirectQuery mode needing to create the dumb date hierarchy. If we have 100 date fields, creating 400 helper columns to hold in memory/increase model size is crazy. Great find!
