In google datastudio, when creating time-series plots, how do you display the time axis in %m/%Y format?
For example, I am interested in displaying 04/2022 instead of Apr 2022, and it seems like datastudio does not allow to use months in decimal number format in a time series (which is a very relevant problem when dealing with fiscal years).
I can convert the date into text with FORMAT_DATETIME("%m/%Y", <original_date>), which displays correctly 04/2022 as a text, but it naturally won't be accepted by a time series.
UPDATE
From my research, as for now it looks like time-series in google data studio only accepts date as a data type for the x-axis (meaning that function FORMAT_DATETIME is useless in this kind of charts). That is perhaps expected, except this date type cannot be displayed in any other way apart from the default format and which poses a serious limitation to those in need of displaying month as a decimal number (01-12) instead of "Jan", "Feb" etc.
In other words, months can only be displayed as month name in google data studio time-series.
