Display data last year and current year in Line and clustered column chart

[XaviOV]

Hi there,
I have a problem displaying data in "Line and clustered column chart"
In the columns I visualize the current data and in the data lines of the previous year.
I would like to visualize the data of this year together with the data of the previous year, I have tried in two different ways, I attach images with the visualization that appears in several different cases.
How could I just visualize last year's data together with this year's?

Regards,

Xavi

[amitchandak · Accepted solution]

You can use a relative date and trailing year measure or YTD measure

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/31"))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))

[XaviOV]

Year behind it's OK

Thanks!

[XaviOV]

Hi @amitchandak ,

Should I use "Relative filter data" or not?

Regards,

Xavi

[amitchandak]

@XaviOV 

If you are using time intelligence function then you need an end date. that can be a date in slicer in relative date filter or end date of the calendar