Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Beginner: Slicer Not Recognizing Year

Thanks for your patience with a beginner question. I'm creating a simple dashboard for email metrics. The data spans 2019-2020 YTD, and looks like this:   Date Delivered Opens Clicks Thurs...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, let me try again. My data spans 1/1/19 - 4/30/20.

     

     

    The graph is putting the Nov and Dec 2019 data to the right of Apr 2020. Why is this happening?

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      It looks like your visual is using a month column without using a year column too.  I would suggest you add a Year column also the x axis.  If you are using the default Date hierarchy, there should also be a Year column with each Date column.  It is recommended to disable that feature and have a separate Date table.  But in your case, you should just need to add a Year column also to X axis.  Without it, it is agreggating all the Aprils, Novembers, etc. together for all years.