Forum Discussion

DEA's avatar
DEA
Frequent Visitor
6 years ago

Date Slicer dynamic

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 t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
DEA
Frequent Visitor
6 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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