Single date picker set default date on Between date picker

[julsr]

Hello everyone!

I'm following these steps to create a Single Date Picker in Power BI:

https://www.linkedin.com/pulse/power-bi-single-date-picker-without-dax-torsten-wanka/, which works fine. I need now this date to be the default date of an end date in a slicer that has a between functionality. How can I do that?

• Once I achieve the previous functionality, I would like to automatically set the start of the slicer to the beginning of the month for that specific date. Is it possible to do so?

[elitesmitpatel]

please share the dummy file and your expected answer mentioned in it.

[julsr]

Thanks. 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!

[julsr]

Hello 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]

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.

[julsr]

The need is because the client wants a single date picker but now we want to use this single date picker to pre-define the dates of the between slicer