Forum Discussion
Month Granularity in date slider
How to select only months in the between/after/before option for a date slicer ? For financial reporting period selection is important and data is generally available on monthly basis. I want to se...
Hi dhritimanpal ,
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Month-and-year-in-one-slicer/td-p/175725
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
Month Year= FORMAT([Date],"mmmm yyyy")
This changes the type to text and not date. so it can only be used as a list or dropdown in a slicer.
So if you have 5 years of data and want to select only 8 months, it is like selecting 8 individual items among 60 items.
This is not a solution