Gantt Chart Month Timeline

[Flxvio043]

Dear all,

I have a question regarding a Gantt chart that I am creating. In this I show at the top as timeline the year, the quarter and the month. However, the month is always timed with 01, 02, 03 and so on. This is partly a bit confusing. Is it possible to change this for example to 1, 2, 3:

Thank you very much and best regards

Flavio

[justISO]

Hi, have you tried simple to convert your month to number with =num(your_month_dimension) ?

[Flxvio043]

Hi @justISO ,

I'm really sorry for my late reply. 

Thank you very much for your answer. Unfortunately I don't have the option in the gantt chart to put a expression like this for the timeline. The Timeline is automatically created and i can not find the option to paste this somewhere in. I only have found this zoom level options which also does not help me with my problem:

Thank you very much and best regards,

Flavio

[Chanty4u]

Select the Gantt chart visualization in your sheet.

In the "Properties" panel, go to the "Data" tab.

Under "Dimension", find the dimension that represents the months in your timeline. It should be named something like "MonthYear".

Click on the dimension to expand its settings.

Under "Formatting", click on the pencil icon to edit the format.

In the "Format pattern" field, enter "M" (without the quotes). This will display the month without the leading zero.

Click "Apply" to save your changes

[Flxvio043]

Hi @Chanty4u ,

Thank you so much for your answer. Unfortunately I think this does not work for a Gantt Chart. I don't have a special Date Dimension. This Dates header is automatically created by the vizilib gantt chart.

thank you and if i missed something or you have another idea please let me know. thank you very much

Best regards

Flavio