Short Dates - Missing Data

Hi teatree,

As you retrieve data from SQL Server database, it depends on which type you closed to connect. If you connect to SQL Server database in Import mode, then you can create a calculated column then change data type to Date mentioned by ankitpatira. And create a column chart, place this calculated column in Axis property, drill down feature is enabled. See:

If you connect to SQL Server in DirectQuery mode, after you create a calculated column then change data type to Date, and place it in Axis property, it will not generate date hierarchy. We need to create columns about year, month and day separately, then place those columns in Axis property. See:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu