Forum Discussion
Multiple date range slicers
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.
Anonymous Tahreem24 amitchandak Greg_Deckler
Hi gilbertendaya ,
Try to refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
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-30/m-p/1284966#M561629
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
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.
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.
Hi gilbertendaya ,
Try to refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
