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 select a range of months eg. Nov FY19 - Dec FY20
How Can I achieve this?
The slicer in the picture is just created by superimposing cards on the slicer date fields.
https://ideas.powerbi.com/ideas/idea/?ideaid=3afaa89a-07de-ea11-bf21-0003ff52cdee
4 Replies
- amitchandak
Super User
dhritimanpal , you have timeline slicer
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview
I do not remember another other handy option. There are few idea's around it
Yes Timeline slicer does work in some level, but the visual is too huge and for 4-5 years of data it cannot be placed in a page.
If labels are hidden then everything gets hidden including the year.Else the visual itself takes half of the page, and for increased no of years, a horizontal scroll will appear which is not at all acceptable.
v-kelly-msftCommunity Support
Hi dhritimanpal ,
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Month-and-year-in-one-slicer/td-p/175725
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
