Parameter to Switch Two Measures on Line Chart Together

[Dave1mo1]

Hi, all.

I'm new to using parameters, so I apologize if this is simple and I've somehow missed it.  I have the line chart below with Previous Year and Current Year values for my "28-Day Moving Average - Units" measure, and would like to add the ability for the user to change from "28-Day Moving Average - Units" to "28-Day Moving Average - Sales" and have both the PY and CY measures change to the ones I've written for Sales.

Ideally, I'd also like to have more than one parameter option, so if the user wanted to see "28-day Moving Average - Margin $/Unit," etc., they can just click the button to change to those measures and change it for both CY & PY.

Doe anyone have any guidance for this particular need?

Thanks so much!

[Anonymous]

Hi @Dave1mo1 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[parry2k]

@Dave1mo1 Wherever in the measure you are using a fixed value of 28, replace that with the measure from the parameter table. 

Select Parameter Value = 
SELECTEDVALUE ( ParamterTable[ParameterTableColumn], 28 ) --28 here is the default value.