Forum Discussion

Sander1401's avatar
Sander1401
Helper II
3 years ago

Interactive date slicer

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 fro...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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!