Forum Discussion
Date Hierarchy stopped working
I have been running reports for about 6 months now and everything is fine. 3 months ago, all my reports suddenly "broke" and now the dates are separating out by days instead of summing into month/yea...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi hrmeehan,
Did you add a date column onto X-axis of a chart? If so, you can click the drill down option on the top left to switch the aggregation level (Day, Month or Year).
Regards,
Yuliana Gu
It turned out to be something simple. I did format the column as a date, but I had to set it to "Start of month" in order for it to roll the days into the month. Thanks!