Add the ability to format the date fields used on chart axis

Hi Arnaud,

Thank you for your reply!

I understand what you're saying, and I actually tried the method you have mentioned below.

Apologies if I wasn't clear enough - what my idea is referring to is specifically the formatting of the date on the axis. For example, in your screen shot, you have 'dd/MM/yyyy'. What I would like is to be able to format this differently i.e. to show '09-Jul' instead of '09/07/2021'. I was also thinking that this option could be placed in the 'Formatting' section of the chart properties.

I tried to achieve this by creating the following calculated column:

Concatenate(DayOfMonth([First Day of Week]),"-",Month([First Day of Week]))

Where [First Day of Week] is calculated via the method described in the link you provided.

I then created a hierarchical column [Year] >> [First Day of Week] an plotted this on the x-axis but I then had the problem that the chart does not order the [First Day of Week] correctly (i.e. in date order) since it's not a date or purely numerical field.

Could you kindly remove the 'Already exists' flag as I don't think this is accurate?
Thanks again for your consideration!

Kind regards,
Sean

Hello,

This is achievable using the custom expression described in this article: https://support.tibco.com/s/article/How-to-show-the-first-day-of-each-week-on-the-x-axis-of-a-chart

For instance, using this custom expression in the X-axis a the bar chart using a date column:

It would be great to have this feature to see trending of metrics by week (dates) rather than week number to be more intuitive. This feature is already available in BI tools like Tableau and users are already used to seeing week dates.