Forum Discussion

Dave1mo1's avatar
Dave1mo1
Icon for Helper III rankHelper III
2 years ago

Parameter to Switch Two Measures on Line Chart Together

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!

 

 

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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