SAS VA - Date Hierarchy, wrong order

[MariaD]

Hi Folks,

I created a date hierarchy (Year --> Quarter --> Month --> Day of week). I'm duplicate the original date variable and I changed the visualization format. I'm using the name of month but I tested with month number and the problem is the same.

After that, I added a graph but the order inside each hierarchy is wrong. For example, shows first the second quarter and then first quarter. 

Any idea?

[Madelyn_SAS · Accepted solution]

Display the graph at the top level of the hierarchy (Year). At the bottom of the graph, click on the Year label. You should see a menu that includes Sort. Sort in Ascending order.

[MariaD]

Thanks! @Madelyn_SAS