Forum Discussion

puru85's avatar
puru85
Helper II
2 years ago
Solved

Adding 12M Average Sales Trend in Line Chart with Dynamic Parameters

Hi Experts, I have a line chart  with the following configuration: X Axis: Date Y Axis: Parameters (A group of measures) Requirement: When "Total Sales" is selected in the Parameter Filte...
General Comment
Need Help
Show and Tell
  • mrandall86's avatar
    mrandall86
    2 years ago

    Hi,

    I think if you go to add line and click the fx over to the right and you can choose to add a measure:

     

     

     

     

  • puru85's avatar
    puru85
    2 years ago

    Hi Anonymous  mrandall86 

    I managed to fix this by using below measure:

    This measure will show [12MAverageSales] only when "Total Sales" is selected in the Parameter Filter. 

    Display12MAverageSales =
    IF (
        SELECTEDVALUE(Parameter[Parameter Order]) = 0,
        [12MAverageSales],
        BLANK()
    )
mrandall86's avatar
mrandall86
Frequent Visitor
2 years ago

Hi,

I think if you go to add line and click the fx over to the right and you can choose to add a measure: