• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display year over year data in pivot table


New Member
Hi all.
I have inserted a sample file with what I would like to do. I have the first pivot table set up to display sales by product. That table has its year slicer and product slicer.
Now the second table I would like to set up to display only 2 years of data. The year selected on the pivot slicer and the previous year for comparison. I want the data to be displayed on a line chart as shown.
Could anyone explain what I would have to do to get that working? I have many pivot tables in my workbook and if I understand how to do one than I can do the rest. I'm not familiar with creating new measures yet, still learning that part.


  • Pivot Charts.xlsx
    51.6 KB · Views: 4
I skip any a power bi file.
About next that another user sent me
... did You use Cross-Posting? ... Of course, You've read Forum Rules ...
Normally, I'll skip those for a week but ...
I did one sample - a grey line.


  • Pivot Charts.xlsx
    64.1 KB · Views: 9