The column chart drill-out data is not sorted properly

[changzhichen]

Scene:

Use the bar chart to show the number of patients received by each department of the hospital. Click the department to drill down the number of patients received by each month. The result is not shown in order, but in disorder

Process:

The SQL script has been sorting upward by month, but when it comes to drilling down on the page, it becomes unhinged

Hope:

Months can be arranged in ascending order

How do you do that?