TimeSeries Chart is showing Year for the January month about superset HOT 5 OPEN

Hi @vasu-ram! I'm here to help you with any bugs, questions, or contributions you might have for the repository. Let's tackle this together!

To fix the issue where the TimeSeries Chart in Superset is displaying the year instead of the month for January, despite setting the Timegrain to "month", you need to ensure that the correct D3 time format is being used.

You can set the time format to display the month and year by using one of the D3 time format options. For example, you can use '%Y-%m' to display the year and month.

Here is how you can set it:

export const D3_TIME_FORMAT_OPTIONS: [string, string][] = [
  [SMART_DATE_ID, t('Adaptive formatting')],
  ['%d/%m/%Y', '%d/%m/%Y | 14/01/2019'],
  ['%m/%d/%Y', '%m/%d/%Y | 01/14/2019'],
  ['%Y-%m-%d', '%Y-%m-%d | 2019-01-14'],
  ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S | 2019-01-14 01:32:10'],
  ['%d-%m-%Y %H:%M:%S', '%d-%m-%Y %H:%M:%S | 14-01-2019 01:32:10'],
  ['%H:%M:%S', '%H:%M:%S | 01:32:10'],
  ['%Y-%m', '%Y-%m | 2019-01'],  // Add this line to include the year-month format
];

Make sure to select the '%Y-%m' format in your chart settings to display the month and year correctly ^[1].

To continue talking to Dosu, mention @dosu.

from superset.

Have you tried adding a date formatter?

from superset.

Tried above it is not working

from superset.

I mean here in the "Customize" tab of the controls, adding an X Axis format. Here's an example:

BEFORE:

AFTER:

from superset.

Thanks @rusackas, I don't know we can change the format on UI, That's fixed

from superset.