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

[puru85]

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 Filter, I want to display it together with the "12M Average Sales Trend."
  
  

  I tried adding the "12M Average Sales Trend" in the trendline, of Line Chart  but there was no option to insert the "12M Average Sales Trend" measure.

Could anyone please help me achieve this? I am open to new ideas or alternative solutions.

Attached is my PBIX:
Parameter Line Chart - Sales and 12M AVG Sales.pbix

Thank you!

[mrandall86 · Accepted solution]

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 · Accepted solution]

Hi @v-xinruzhu-msft  @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()

)

[v-xinruzhu-msft]

Hi @puru85 

Based on your description, you can add the measure to the y-axis directly.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mrandall86 · Accepted solution]

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: