Forum Discussion
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...
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
Microsoft Employee
Microsoft EmployeeIt 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.