Period slicer with slider, month-year format instead of default format

[bsz412]

Hi, 

I was requested to create a date slicer which does not display day, only month and year. Slider version would be the best, or if that is not possible a separate start date end date selector would do. 

What I have tried so far: 

- adding an additional column with the required Month-Year (e.g Jan-2022) format to my calendar lookup table. This is handled as a text, so if I put it on a slicer only list and dropdown options are available, not the "between" option with a slider.

- If I add only the year or only a month as a number it works, but if I handle year and month separately then I end up with 2 slicers which is a bit too much. Maybe if the month could be changed to text format and keep the slider somehow that could be acceptable if there is no other option

- Month-year format as a dropdown, but it is not what the client wants

- the timeline slicer: too big, not accepted by the client

I saw some solutions where start and end date was on two different slicers, and then this had to be added as a filter function to the DAX measures. Sales Between Date rage DAX filter | Power BI Exchange (pbiusergroup.com)

My concern with these kind of solutions is that for each and every DAX measure I want to filter by date I will have to add these filter condition as part of the DAX code, if I got the concept right. I find that too complicated and I want to avoid such complications. I am not sure if there is a simple solution for this issue. 

[Gshepo84]

I layered 2 cards over the slicer. You could do this with any desired format.

MAXPERIOD = MAX(_MasterPeriods[Period])

MINPERIOD = MIN(_MasterPeriods[Period])

[v-angzheng-msft · Accepted solution]

Hi, @bsz412 

A more usual month year format is what they want, eg. Jan21, or Jan-2021, sthg like that....

As far as I know, this cannot be done. Range slicers can only work on date or number types.
One option is to use two slicers acting together as mentioned in your question.
The other option is what @TheoC  mentioned above.

Unfortunately, you can't use text formatting in a range slicer.

Use the numeric range slicer in Power BI

Your demand is a good idea, while it is not supported to implement in Power BI currently.

You can vote up a idea or submit a idea to improve the Power BI.

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

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TheoC]

Hi @bsz412 

Can you have your slicer as YYYYMM (i.e. Year and Month) like below?

Hope this works for your client?

Theo

[PierreL69]

Hi this is a nice idea but the issue here is that it generate unwanted value like 201422 / 201423 / 201424 / .... etc.... which in a date context YYYYMM do not exist

[TheoC]

@PierreL69 you're right. Unfortunately, this looks to be a glitch as it should only be considering the values in the field, not those that do not exist.  Good pick up and apologies this didn't work appropriately.

[bsz412]

Thanks for sharing this idea. A more usual month year format is what they want, eg. Jan21, or Jan-2021, sthg like that....