Forum Discussion
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 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.
3 Replies
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.
