cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
enlamparter Helper I
Helper I

Need "between" slicer to select consecutive range of months (not days)

I want to have a slicer that allows users to select data from a consecutive range of months (Jan-Jul, Feb-Sept, etc.) but I don't want them to have the freedom to select it at the "date" level, because all data from each month lives on the 1st day of the month (so selecting January 2nd would eliminate all January data from view).

 

Any way to make this happen, or am I stuck using a multi-select list slicer?

3 REPLIES 3
Microsoft v-huizhn-msft
Microsoft

Re: Need "between" slicer to select consecutive range of months (not days)

Hi @enlamparter,

Based on my understanding, you can create a calculated column using the formula: Month = MONTH('Calendar'[Date])

Then add the 'Month' column in slicer, select between mode, you can select the month range as follows.

1.PNG

If you still have other problem, don't hesitate to ask.

Best Regards,
Angelia

enlamparter Helper I
Helper I

Re: Need "between" slicer to select consecutive range of months (not days)

Thanks Angelia, that does work as long as my data only spans one year, but since my data spans 2016 and 2017, this doesn't quite serve the purpose I need it to. I probably should have specified that in my original question!

Microsoft v-huizhn-msft
Microsoft

Re: Need "between" slicer to select consecutive range of months (not days)

Hi @enlamparter,

If your data only has year, rather than the formate year/month/day? How do you select the consecutive range of months (Jan-Jul, Feb-Sept, etc.) You must have month level.

Best Regards,
Angelia

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors