Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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 retur...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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/823601