topic Re: Limit a date slicer with another date slicer based on maximum selected date in DAX Commands and Tips

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

Anonymous — Thu, 28 Apr 2022 13:18:39 GMT

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)

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

JirkaZ — Thu, 28 Apr 2022 13:22:33 GMT

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.

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

Anonymous — Thu, 28 Apr 2022 13:30:06 GMT

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.

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

JirkaZ — Thu, 28 Apr 2022 13:33:34 GMT

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

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

Anonymous — Thu, 28 Apr 2022 14:05:03 GMT

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

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

JirkaZ — Thu, 28 Apr 2022 14:12:37 GMT

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

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

Anonymous — Thu, 28 Apr 2022 14:59:01 GMT

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

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

Anonymous — Wed, 04 May 2022 07:43:33 GMT

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