Forum Discussion
How to make a filter by months
I want to change my date range filter to be able to just click months (and you get the entire month as a display)
I don't want my client to be able to do half months or Jan16-march 5 - I want Jan, Feb, March, but also with the year. How do I do this?
Anonymous , if you are getting date Hierarchy then you can only have columns like Year and month -https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing
and use in slicer as list
Or you can create month year column in date Table and use that
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
1 Reply
- amitchandak
Super User
Anonymous , if you are getting date Hierarchy then you can only have columns like Year and month -https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing
and use in slicer as list
Or you can create month year column in date Table and use that
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")