Limit a date slicer with another date slicer based on maximum selected date

[Anonymous]

Hi Team,

I am looking for a solution here. Basically I want to filter(A) one date slicer based on maximum date selected in another date slicer(B).

Let's say If I am selecting any particular date in slicer B then other slicer A should show only previous 7 days of selected date from slicer B.

Anothe example is like I am selecting 20th April in slicer B then slicer A should show only 7 days date range like (12th april to 19th April only)

[Anonymous]

Hi @Anonymous ,

It is not yet possible to use slicers to dynamically control other slicers. Calculated columns and tables are not recalculated when the slicer changes. In other words, the slicer does not interact with the calculated table and calculated columns, and no filtering is possible.

Someone has proposed a similar idea and you can vote for this idea.

Microsoft Idea (powerbi.com)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Hi JirkaZ, Thanks for replying.

I need the slicer A to show minus 7 days  only from maximum selected date from slicer B. 

I am not sure what should be the desired dates here because it totaly depends on the selection of date from slicer B. I just need to see (-7 days) of that selected date.

[JirkaZ]

The desired dates will result from a calculation within the measure... example would be to use 
DATEADD(DimDate[Date], [MaxDateFromSlicerB], -7, DAY)

[Anonymous]

It looks like I would need two date table instead of one for each slicer. Correct me if I am wrong.

[JirkaZ]

Yup - the one for slicer B wil be disconnectet from the rest of the data model

[Anonymous]

Hi JirkaZ,

I am using below dax however it is throwing some error.

slicer = DATEADD(Calendar2[Date], [max date], -7, day)

Here max date is from calendar 2

[JirkaZ]

Create a measure that will hold the desired dates and that will return 1 or 0 based on the date check. Filter Slicer A by that measure where the value = 1.