How to make a filter by months

[Anonymous]

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?

[amitchandak · Accepted solution]

@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")