Home › Forums › Power Pivot › Graph sales YTD last year Tagged: Graph, YTD last year This topic contains 0 replies, has 1 voice, and was last updated by Alf 2 months, 3 weeks ago. Viewing 1 post (of 1 total) Author Posts January 31, 2019 at 3:46 pm #12315 AlfParticipant Started: 7Replies: 7Total: 14 Hi I hae a graph showing sales for each month in a line diagram. There are 2 lines. One for 2018 and one for 2017. I have a slicer which I use to choose what months i would like to have in my graph. The problem is if i choose e.g jan, feb, march i 2018, only jan, feb, march in the 2017 line is visible. How can i always show the dates less than the biggest date. What i want is that all twelve months for 2017 is visible, and only the three months for 2018. I am currently using the measure : calculate([sales];sameperiodlastyear;date)) for 2017 Hope anyone has a good idea 🙂 Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.