Forum Discussion

AsNa_92's avatar
AsNa_92
Resolver II
1 year ago

two date slicers with interaction

Hi ..

 

I have 2 date slicers, one is d-1 as a check box and the other is period (from - to).

 

I want the user to choose one of these not all to be selected. So if user checked the d-1 the period will be disabled and the way around.

 

I have the interaction for both to be filtered if one is selected, but it doesn't work. 

Could you please help.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, AsNa_92 

     

    First you need two date tables with no join relationship. After selecting the date range, you can filter the dropdown slicer at the same time, and vice versa may not work.

    Measure = IF(SELECTEDVALUE(Date2[Date2])>=MIN(Date1[Date1])&&SELECTEDVALUE(Date2[Date2])<=MAX(Date1[Date1]),1,0)

    Please see the attached document.

     

    Best Regards,

    Community Support Team _Charlotte

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

    • AsNa_92's avatar
      AsNa_92
      Resolver II
      1 year ago

      Hi Anonymous 

       

      thanks for your reply, it works somehow but the date in period keep the same selection.

      is there any way to show it as one date only?

       

      this what i get:

      If i want to select dates before the one in checkbox it return grey..

       

       

       

      and this what i need:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi, AsNa_92 

         

        After testing on my end, I can't control the output of only one date in the interval.

        In this case it is possible to output only one date.

        Once you change the slicer format, it doesn't work.

        Hope this helps you.

         

        Best Regards,

        Community Support Team _Charlotte

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