Basic Date Slicer Used on One Page to Drive Relative Dates on Another Page

[Esef]

Hello,

I am working on report where the first page is a summary page and is driven by a basic date selection. Elsewhere in the report I am showing trends. I would like for the selected date from the summary page to be the basis for the relative date on the trends page.

For Example

Summary page slicer selection = 7/31/2021 to drive trends page data to be <=7/31/2021

What is the best way to accomplish this? ideally, I would like the user to only have to filter in one place.

Thanks in advance for any help.

[v-yangliu-msft · Accepted solution]

Hi  @Esef ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Slice date =
CALENDARAUTO()

2. Use the [date] column of the Slice date table as the slicer in Page1 and Page2 respectively.

3. Select Sync slicers in View, so you can select the slicer of Page1, which will be synchronized to the slicer of Page.

4. Create measure.

Flag =
var _select=SELECTEDVALUE('Slice date'[date])
return
IF(MAX('Table'[date])<_select,1,0)

5. Place Measure[Flag] in the Filter in Page2, set is=1, and apply filter.

6. Result.

Select 2021.7.31 in Page1, and display data less than 201.7.31 in Page2.

Best Regards,

Liu Yang

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