Multiple date range slicers

[gilbertendaya]

Hi guys! 

Need your assistance on my project.

Currently, we're migrating from one visualization to Power BI.

The visualization has below filter date range:

When we click the Between option, calendar option will be displayed.

How can we do this in Power BI?

We assume to use 2 slicers like below:

So if the user wants to use the Last/Next/This option, he will use the first slicer and changes will take effect to all visualizations in the page. The 2 slicer (between) should be disabled and vice versa. Is this possible? 

Please advise.

@v-eqin-msft @Tahreem24 @amitchandak @Greg_Deckler 

[Tahreem24]

---

So if the user wants to use the Last/Next/This option, he will use the first slicer and changes will take effect to all visualizations in the page. The 2 slicer (between) should be disabled and vice versa. Is this possible? 

---

@gilbertendaya , If you want enable only one Date slicer option at a time so use the combination of Button and Bookmark features. If you want to visit the link in my singature there is one Toggling option between Tabular View and Graphical View so you can also make something like that.

[gilbertendaya]

hi @Tahreem24  thank you for the feedback. I saw the button and bookmark feature and it seems it can only reset the page. Is there a way to enable or disable slicer? Can you provide me a sample on how to do this?

thank you for the support.

[v-lionel-msft · Accepted solution]

Hi @gilbertendaya ,

Try to refer to my .pbix file.

Best regards,
Lionel Chen

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

[amitchandak]

@gilbertendaya , In power bi You have relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Date Slicer you can change to between, before, or after slicer.

I think what you are looking for, you might have to build something like : https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

[gilbertendaya]

@amitchandak thank you for the reply.

I saw the relative date for slicer but I'm afraid this is not available to change once we deploy the dashboard to Power BI service. 

That's why I'm planning to use 2 slicers hmm