Date Slicer dynamic

[DEA]

Hi,

I have a simple data table witht dates and prices.

I need to create a report where the user selects a date in a slicer and the report shows a chart with the prices over the last 6 months from the selected dates.

I.E if the user selects 10/31/2019 the chart should show prices from 04/30/2019 to 10/31/2019 but if the user selects 06/30/2019, the chart should show prices from 12/31/2018 to 06/30/2019.

[v-jayw-msft]

Hi @DEA ,

Please check follow steps and see if the result achieve your expectation:

1. Create calculated table:

    Table 2 = DISTINCT('Table'[Date])

2. Create measure:

    Measure =

    VAR sv =

        FORMAT ( SELECTEDVALUE ( 'Table 2'[Date] ), "YYYYMM" )

    VAR ls =

        FORMAT ( EDATE ( SELECTEDVALUE ( 'Table 2'[Date] ), -6 ), "YYYYMM" )

    RETURN

        CALCULATE (

            MAX ( 'Table'[Price] ),

            FILTER (

                'Table',

                FORMAT ( 'Table'[Date], "YYYYMM" ) > ls

                    && FORMAT ( 'Table'[Date], "YYYYMM" ) <= sv

            )

        )

3. Result would be shown as below:

BTW, Pbix as attached, hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[DEA]

did not work. I must be doing something wrong. Thanks

[v-jayw-msft]

Hi @DEA ,

Could you please share some sample data and excepted result to me if you don't have any Confidential Information.

if so, Please upload your files to One Drive and share the link here.

Best Regards,

Jay