How to create a sliding slicer of months for dates

[Anonymous]

I would like my report to have a slicer that allows for a Start Month and End Month to be selected on a slider. I don't want the slicer to be at date level, but at Year-Month level. How can this be done?

[v-yingjl]

Hi @Anonymous ,

You can try to use 'Timeline' custom visual to meet your requriement, set the filter level as month:

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-yingjl. I had already found the timeline visual, but found it too bulky and cumbersome for my needs.  For example, it takes up a large amount of the screen in height. And I don't want the users to have to scroll off to the right to find the end date - I want the slider to fit within the width I set, and have all the month values available to be "slid" to.

[v-yingjl]

Hi @Anonymous ,

As far as I know, if you want to set the width for the slicer when using sliders at the same time, I'm afraid currently power bi could not have a suitable visual to meet your requirement.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous , you can do this in either of the following ways:
1. Use the auto date/time hierarchy present in Power BI: Where you expand the levels of date field and select Year. month from available options.

2. Create a calculated column as below: A more recommended approach, as you can specify the format of month/year as per your needs. You can sort the column by Month number.

Year-Month =

VAR _year = FORMAT([Date], "yyyy")

VAR _month = FORMAT([Date], "mmmm")

RETURN

_year &"-"&_month

Month number = FORMAT([Date], "mm")

Did I solve your problem?

If yes, please mark my solutions as Accepted! A kudos will be apprecited too! 🙂

[amitchandak]

@Anonymous , Create a month year column and use that

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Sort month year on MOnth year sort

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

When I add a column that contains YYYY-mmmm to the slicer, there is no option to make the slider visible. See the options below

[mahoneypat]

You can have a numeric month column with MONTH('Date'[Date]) and use that in your slicer.

Regards,

Pat

[Anonymous]

No, the report users need to see the slider start and end dates to display as "Nov 2019"