2 slicers of same dates with different formats on same page.

[firdows_2407]

I have 2 slicers of same date on same page, 
one date is vertical list with single select slicer
and other date is in before date slicer format
If I select one date in first slicer, the other slicer should start from min(Selecteddate) and 
End date should be Max(Selecteddate)
like 
CalendarTable = CALENDAR(DATE(2009,4,2), TODAY())
this is my table.
For Example,
in first slicer, I select 18-07-2024
In second slicer, it should take from 02-04-2009 to 18-07-2024

its coming like this

But, I want like this but with interactions

Is there any possible way to sync both the slicers?

Please suggest any solution to this.
Thanks in advance!!

[Anonymous]

Hi @firdows_2407 ,

The slicer visual before date can not be filtered by another slicer. Based on my testing, please try the following as workaround:

1.Create the two calendar table.

Table = CALENDAR(DATE(2009,4,2), TODAY())

2.Create the new table 2.

Table 2 = {"True","False"}

3.Create the new measure to filter the date.

Measure 3 = 
VAR _Slicer = MAX('Table'[Date])
RETURN 
IF(MAX('SlicerTable'[Date]) <= _Slicer,TRUE(),FALSE())

4.Drag the measure into the Preselected visual.

5.Select the date in the first slicer. The result is shown below.

You can also raise a new idea and add the comment.

Home (microsoft.com)

Best Regards,

Wisdom Wu

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

[firdows_2407]

@Anonymous , Can you please explain me what is this value in the below screenshot refers to?

[Anonymous]

Hi @firdows_2407 ,

The value is table 2 column.

The Preselected visual requires a login to power bi. Can not upload the pbix file.

Best Regards,

Wisdom Wu

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

[firdows_2407]

Thank you for your quick response, I've tried your technique, but it's still not working as expected. 

I've tried another solution and it is working fine.

Thanks @Anonymous 

[Anonymous]

Hi @firdows_2407 ,

Based on the description, you have solved the problem.

You can share the solution and please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[firdows_2407 · Accepted solution]

Hi @Anonymous ,

Here, I have not used the slicer options instead i have made some changes in logic level by using my tables.

Actually I'm creating an aging report for that purpose, I want this second slicer. Now instead of using slicer option, I have used like this

0 - 7 Days =

VAR SelectedDate = MAX('DateTable'[Date])

VAR StartDate = DATE(2009, 4, 2)

RETURN

    SUMX(

        FILTER(

            'AGING_TABLE', 

            'AGING_TABLE'[Posting Date] <= SelectedDate &&

            'AGING_TABLE'[Posting Date] >= StartDate &&

            DATEDIFF('AGING_TABLE'[Due Date], SelectedDate, DAY) >= 0 &&

            DATEDIFF('AGING_TABLE'[Due Date], SelectedDate, DAY) <= 7

        ),

        'AGING_TABLE'[Amt in LC]

    )

Here I took direct start date to select date, and it is working fine.

Thanks & Regards

Firdows

[bhanu_gautam]

@firdows_2407 , You can use DAX to acheive this

Create a Measure for the Selected Date:

   SelectedDate = SELECTEDVALUE(CalendarTable[Date])

Create a Measure for the Min Date:

   MinDate = MINX(ALL(CalendarTable), CalendarTable[Date])

Create a Measure for the Max Date:

MaxDate = IF(ISBLANK([SelectedDate]), MAXX(ALL(CalendarTable), CalendarTable[Date]), [SelectedDate])

Then create a new table 

DynamicDateRange =

   VAR MinDate = MINX(ALL(CalendarTable), CalendarTable[Date])

   VAR MaxDate = IF(ISBLANK([SelectedDate]), MAXX(ALL(CalendarTable), CalendarTable[Date]), [SelectedDate])

   RETURN

   CALENDAR(MinDate, MaxDate)

Use the DynamicDateRange table for the second slicer. This table will dynamically adjust its range based on the selection in the first slicer.

[firdows_2407]

@bhanu_gautam I tried using this technique, however the second slicer does not function based on the first slicer's selection.