Date Filtering - Converting Dates To Months

[HenryJS]

Hi all,

I want to create a Date Filter drop down which has a list of the months.

I have a column with dates in. How can I create a date dropdown which then only sows the months and will return any dates in that month?

Data:

Dropdown:

Thanks,

Henry

[v-lid-msft · Accepted solution]

Hi @HenryJS ,

We can create a calculated column use Format function to meet your requirement:

MonthSlicer = FORMAT([Date],"MMMM")

 

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

Best regards,

[amitchandak]

Change it to between from down arrow option or

If you are seeing a date Hierarchy then on Slicer drag only Month and Year or cross others it will change

Else create a calendar table and have month year column in that and use that in filter

Refer

https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601