Need a way for date in between slicer to dynamically change to and from dates

[Anonymous]

Hi folks,

I am working on a huge dashboard and have many slicers on the report page. I have 2 slicers on top that are as below:
1. Week ending with date

2. Weeks before the week ending date

I need another slicer below for one of my bar chart visuals which will show only dates that will be within the date range selected above. I have the slicer as below but the dates is all dates from the date table:

I use the below measure to filter the slicer 

dateBetween = 
VAR selected = SELECTEDVALUE('Calendar'[Date])
VAR C = CALCULATE(SWITCH(SELECTEDVALUE('Period Length'[Periodlength]), "4 weeks",  28 , "52 weeks", 364, "1 week", 7, "104 weeks",728 , "24 weeks", 168, "26 weeks", 182, "12 weeks", 84)) 
VAR minDate = selected - C
RETURN 
    IF (
        SELECTEDVALUE ( 'Static Calendar'[Date] ) <= selected
            && SELECTEDVALUE ( 'Static Calendar'[Date]) >= minDate,
        1,
        0
    )

This works on a vertical list of values in slicer but doesn't work on Between dates slicer screenshot below:

Is there a way it will show the start date and end date in the slicer in between date format?

Thanks for you help!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
This happens because to have a slicer as range you need to have all days between the range.

Only single-level consecutive numbers/dates are supported.
It does not work on "torn" sequences

Therefore, it will work on 1,2,3,4,5
However, it will not work on 1,3,5
The same thing for dates.

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