Home Forums Power Pivot Graph sales YTD last year

This topic contains 0 replies, has 1 voice, and was last updated by  Alf 6 months, 3 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #12315

    Alf
    Participant
    • Started: 8
    • Replies: 7
    • Total: 15

    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 🙂

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.