Forum Discussion
Continued ContributorSingle date picker set default date on Between date picker
Continued ContributorThanks. Look, I have two sheets in my PBIX file (find it attached below): one with a single date picker and another with a Between slicer. I want my single date picker date to become the end date of my between slicer (1 in the image), and then I want the start date of my slicer to become the first day of the month based on the previous step (2 in the image).
https://drive.google.com/file/d/1NBmwpX_mrNqpCm_gKIG_5WS6LHy4S5O7/view?usp=sharing
Thanks!
Continued ContributorHello everyone! Here's an updated PBIX file with more data. Still, I have not found a way to solve this issue, thanks!
FYI elitesmitpatel
- Ashish_Mathur
Super User
Hi,
What is the purpose of the the between slicer. Once a date is selected in the single date picker slicer, in any measure, you can create a virtual date table of all dates from the beginning of the month to the selected date.
- julsr
Between Slicer allows the user to select multiple dates in a period to refresh information and data. So you are saying that I should use my date table to create another date table which will be used only for this section of Between Slicer, right?
- Ashish_Mathur
No, i am questioning the very need to create 2 date slicers. On second thoughts, just have the between date slicer.
