Forum Discussion
Date Filtering - Converting Dates To Months
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
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,
2 Replies
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-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi 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,
