Forum Discussion

julsr's avatar
julsr
Continued Contributor
1 year ago

Single date picker set default date on Between date picker

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?
Need Help
Show and Tell
Tips and Tricks

7 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    1 year ago

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

    • julsr's avatar
      julsr
      Continued Contributor
      1 year ago

      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!