Changing date range filter using a measure

[dabeans518]

Is it possible to change the value of a date range filter using a measure? 

I have this period filter that is in page1

it only affects visuals like table, cards, etc.
But I don't know if it's possible to change the value of a date range itself.

This date filter is in page2. Hopefully there's a workaround.

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, @dabeans518 

You can try using slicer synchronization:

1.Firstly, modify the slicer on the page:

2.Secondly, create the following measure:

MEASURE =
VAR cc1 =
    MAX ( 'Table'[Column1] )
RETURN
    SWITCH (
        TRUE (),
        cc1 = "YTD", IF ( YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () ), 1, 0 ),
        cc1 = "MTD",
            IF (
                YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
                    && MONTH ( MAX ( 'Table 2'[Date] ) ) = MONTH ( TODAY () ),
                1,
                0
            ),
        FALSE ()
    )

3.Apply the measure to the slicer:

4.Here is the final result, which I hope meets your requirements:

It is recommended to change the slicer style to “tile,” as the current “between” style may cause issues.

For detailed information, please refer to:

Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[lbendlin]

That would be a question for your data model. While you cannot programmatically set slicer boundaries the field that feeds the slicer can be impacted by external filters.