I have created a chart with a 2-level hierarchy. This is working correctly. In the chart I have defined a sort on the first hierarchy field because I can not select the hierarchy as I can when defining the category.
Result is that the first level of my chart is sorted correctly but when I drill deeper the second level (year field) is not sorted.
Ideal would be if I can define the sort when defining the hierarchy. Maybe a feature request?
Second thoughts :
When using one dataset to generate multiple charts with different hierarchies you will need to adjust your work to have different datasets with different sorting for the different hierarchies. That is not optimal.
And as there is already so much you can configure in the chart-formatting options that it might be better to add a sort option to the different levels of a hierarchy. In that case you can use one dataset for different charts with different hierarchies.
You have started a good topic which will help other users to visualize their data much easier, we have made a note and pass to our enginerring and hoping to have this implemented in few months (this depends on the list of features priority). If you have customer ID, please open support ticket with your login and we will provide you a quick patch as soon this feature is available internally.