topic Re: How to reference slicer from another based on user selection using switch in dax? in DAX Commands and Tips

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

ironboy0418 — Fri, 17 Mar 2023 01:22:45 GMT

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

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

amitchandak — Fri, 17 Mar 2023 01:47:06 GMT

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

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

ironboy0418 — Fri, 17 Mar 2023 02:21:22 GMT

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