How to reference slicer from another based on user selection using switch in dax?

[ironboy0418]

Hello, I am trying to reference a date column to a slicer. First, I have created a query table that has this selection/values:

Slicer 1:

The objective is when I selected a value in slicer 1, the selection should update in slicer 2. Here are the example options for Quarterly, Monthly, and Weekly from my date table that I am trying to reference with:

Quarterly:

Monthly:

Weekly:

Here is my dax formula. However, I am not sure how to write for it to be referenced using switch:

RelativePeriodSelection =

VAR SelectYearQuarter = SELECTEDVALUE('Date'[YearQuarter])

VAR SelectYearMonth = SELECTEDVALUE('Date'[YearMonth2])

VAR SelectWeekStart = SELECTEDVALUE('Date'[Start of Week])

VAR DynamicDateValue =

    SWITCH (SELECTEDVALUE(Period[RelativeDate]), "Quarterly", SelectYearQuarter, "Monthly", SelectYearMonth, "Weekly", SelectWeekStart

    )

RETURN

DynamicDateValue

Result:

cc @tamerj1 

[amitchandak · Accepted solution]

@ironboy0418 I think this may help, the field parameter feature, You may have rename your columns

Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ

[ironboy0418]

Thanks for this! @amitchandak I didn't realize that there is an option for this 🙂 great!