Slicer options return incorrect data

Hi, edant ;

Because the conditional statement of switch takes the first condition [Date] = TODAY (), "Today" first, if your date meets today, then it can only return a result today instead of "Last Week";
Maybe you can try the following methods:
1.enter table.

2.create a flag measure.

flag = 
SWITCH (
    MAX ( 'slicer'[slicer] ),
    "Today", IF ( MAX ( 'Table'[date] ) = TODAY (), 1 ),
    "Last Week",
        IF (
            DATEDIFF ( MAX ( 'Table'[date] ), TODAY (), DAY ) <= 7
                && MAX ( 'Table'[date] ) <= TODAY (),
            1
        ),
    "Last Month",
        IF (
            DATEDIFF ( MAX ( 'Table'[date] ), TODAY (), DAY ) <= 30
                && MAX ( 'Table'[date] ) < TODAY (),
            1
        ),
    "Last 3 Months",
        IF (
            DATEDIFF ( MAX ( 'Table'[date] ), TODAY (), DAY ) <= 90
                && MAX ( 'Table'[date] ) < TODAY (),
            1
        )
)

3.apply it into filter.

The final output is shown below:

If it does not meet your needs, It would be great if there is a sample file without any sesentive information here.
It makes it easier to give you a solution.

Best Regards,
Community Support Team_ Yalan Wu

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