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 |
| Thursday, January 24, 2019 | 4719 | 1752 | 229 |
| Thursday, April 23, 2020 | 4775 | 1844 | 233 |
When you set the slider timeline to span the year, such as "12/1/2019 - 4/30/2020," the visual puts the December 2019 data to the right of the April 2020 data, as if it is ignoring the year. What did I do wrong?
5 Replies
Anonymous Please add the Year and Month both from the Date Hierachy to the X-axis of the visual. Then expand the hierachy using the tree option on the visual. Finally, set the X-Axis type to categorical. Image attached below showing these steps.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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.
