Display last year and this year metric in area chart using field parameters

[uj91]

Based on a field parameter : 

PerOverview_Digital = {

    ("impressions", NAMEOF('Reporting.Digital'[Total Impressions_Digital]), 0),

    ("Clicks", NAMEOF('Reporting.Digital'[Total Clicks_Digital]), 1),

    ("Spend", NAMEOF('Reporting.Digital'[Total Media Cost_Digital]), 2),

    ("Video Starts", NAMEOF('Reporting.Digital'[Total Video Starts_Digital]), 3)

}

i want to comapre this year and last year (Measures from above parameter and used in a slicer) in a area chart visual. Impression taken as example in below visual which will change according to the parameter. 

Any suggestions help ? 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[MFelix · Accepted solution]

Hi @uj91 ,

For this you need to combine your Field Parameters with Calculation group that will have the calculation for each of the lines.

Just create a new Calculation Group with two values:

Current Year = SELECTEDMEASURE()

Previous Year =CALCULATE (SELECTEDMEASURE(), DATEADD(Calendar[Date], -1, Year))

If you use this on the legend of your chart you should be able to get the expected result.

See an example attached.

[v-dineshya]

Hi @uj91 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @MFelix , Thank you for your prompt response.

Hi @uj91 , Could you please try the proposed solution shared by @MFelix  ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[v-dineshya]

Hi @uj91 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh