Hi,
I have a chart that shows the capacity per day. The x-axis shows the dates. However, the sorting of the x-axis on dates is not working properly since it sorts alphabetically instead of numerically. E.g. 10 - 11 - 1, …, 20, 21, 2, … 3,30,31… instead of 1,2,3, etc.
The year, month and day in the cube are base on 1 column: date_day_only.
I think I can create a workaround here by adding the day in the view like 01,02,03 etc. but I think I am missing something here in the settings.
![](https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/9bac3a65-a75e-4a44-a19f-156f460fd98c.png)
![](https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a255488e-4cfb-413c-a123-2461c9b3fb16.png)