Forum Discussion

mshamsiev's avatar
mshamsiev
Icon for Helper I rankHelper I
9 years ago
Solved

Comparing 2 Sets of Data on Line Graphs

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 

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

4 Replies

    • dkay84_PowerBI's avatar
      dkay84_PowerBI
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago
      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.
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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