Comparing 2 Sets of Data on Line Graphs

[mshamsiev]

Hi all,

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?

Thanks,

Mike 

[v-ljerr-msft · Accepted solution]

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. 

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

[mshamsiev]

Bump

[dkay84_PowerBI]

Add a column to your data table for the year (with your custom year range i.e. Mar '15 - Mar '16). Then, just add this field to your chart as the Legend value.

[mshamsiev]

Hey @dkay84_PowerBI,

Cheers for the reply 🙂 Is that through a DAX function? 

-Mike