Create a date slicer (slide) , based on what is selected on another Date_Type Slicer

[tina345]

Hi All,

   I have a data set with Sales and Delivery Date.I have added Screen Shot with data set  as well .My requirement is to have a date_type slicer(slicer_1) with sales and delivery date, based on what user select , I need to have another date_slider (Slicer_2).

    I created selected_value measure based on what is selected on date_type slicer , and was planning to create slicer_2 based on that measure, however it looks like I can't link that slicer with measure.

   Date_Type Slicer : Sales_Date and Delivery_Date

   Date Slider          : Another slicer based on what is selected above from Date_Type slicer

  m_Selected_Value = if(   SELECTEDVALUE(Sheet[DATA_FILTER])= "Sales_Date" , "Sales_Date", "Delivery_Date")

Data Set:

Product_ID	Region	Sales_Date	Delivery_Date
100	East	1/1/2023	1/5/2023
100	West	2/3/2023	2/10/2023
200	East	3/2/2023	3/5/2025
300	East	3/15/2023	3/18/2023
400	North	4/1/2023	4/15/2023
500	South	5/1/2023	5/15/2023

  Thanks

[Alex87 · Accepted solution]

Hello,

First, you need a Date Table marked as Date and a slicer table with the two options (Sales Date/ Delivery Date = slicer 1)

Second, you need a DAX flag that you apply to the slicer 2 (coming from the Date table - I chose Month & Year but it can be changed to something else like day date etc)

The formula for the Flag is = 

Flag =

VAR __CurrentSelection = SELECTEDVALUE(Slicer[Slicer], "Sales Date")

VAR __Boolean =

IF(

    __CurrentSelection = "Sales Date",

    NOT(ISBLANK(

        CALCULATE(

            MAX('Data'[Sales_Date]),

            ALL('Dates'),

            'Data'[Sales_Date] IN VALUES('Dates'[Date])

        )

    )),

    NOT(ISBLANK(

        CALCULATE(

            MAX('Data'[Delivery_Date]),

            ALL('Dates'),

            'Data'[Delivery_Date]  IN VALUES('Dates'[Date])

        )

    ))

)

VAR __Result = IF(__Boolean, 1, 0)

RETURN

__Result

Is this asnwering your question? If so, please mark it as a solution

Best regards,

Alex Badiu