Comparing 2 Sets of Data on Line Graphs

Hi mshamsiev,

---

I'm trying to compare volume of requests across two years and chart in on a line graph. Eg. line graph comparing Mar16-Mar17 on one line and Mar15-Mar16 on the secondary line. Any idea how I can do this?

---

If I understand you correctly, you should be able to make use of SAMEPERIODLASTYEAR Function (DAX) to create a new measure to do your calculations for the same period last year, which should be easier in your scenario. :smileyhappy:

For example, if you want to compare the total sales of Mar16-Mar17 and Mar15-Mar16, then you can show both [Total Sales] and [PY Sales] as the Values for the Line Chart, and use a Slicer to filter the date to Mar16-Mar17.

Total Sales = SUM(Sales[Revenue])

LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))

Regards