Forum Discussion
Beginner: Slicer Not Recognizing Year
Super UserThe information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
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.
