Interactive date slicer

[Sander1401]

Hi all,

I need help with an interactive date slicer.
I have a dashboard with a date parameter which can switch the X-axis of a visual between weeks and months.
Not only that, but when I switch from week to month (and vice versa) the range changes. I did that because I didn't want to have a slider to look for the most recent dates in the visual.
Everything works, the visual, the table, so that is really cool. Unfortunately when I change the table into a date slicer, that one doesn't work.
The date slicer only shows the date range of the weeks, also when I choose Month on the parameter.
(With weeks I have a range of 5 weeks, and with months 2 months).

I have added a link to an example dashboard:
Dashboard date filter 

The date range of the datasource is as of 1st of October 2022.
When selecting weeks it should show 28th of November until now.
When selecting months it should show 1st of November  until now.

Can anyone please help me out why the date slicer only shows the range of 28th of November until now and how I can solve this?

[Sander1401]

Yes, I would really like you to report this internally!
I think this is a bug which should be solved.

[v-jingzhang]

Hi @Sander1401 

Based on my test, when switching the date slicer to Vertical list/Tile/Dropdown style, it works well to show dates starting from 2022/11/1 for "Month". However when switching it to range styles (Between/Before/After), it always shows 2022/11/28 as the start date and this date cannot be changed. 

I tried another measure like below as a filter on the date slicer, the result is the same as your measure. I think the problem is caused by the slicer style rather than the measure. 

filter week/month =
SWITCH (
    MAX ( 'Parameter - date visual'[Parameter - date visual] ),
    "Week",
        IF (
            MAX ( 'Datumtabel'[Date] )
                >= TODAY () - WEEKDAY ( TODAY (), 2 ) + 1 - 35,
            1,
            0
        ),
    "Month",
        IF ( MAX ( 'Datumtabel'[Date] ) >= EOMONTH ( TODAY (), -3 ) + 1, 1, 0 )
)

Do you want me to help report this issue internally? But I'm not sure when/whether this will be fixed after reporting. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!