How to use text value on X axis in visual?

[sagmukhe]

formatDate function always returns string data type, hence no need to do further toString.

Reference Link: formatDate - Amazon QuickSight

Further to this, I believe formatDate(Date, ‘WK’) is unsupported. I have tried to respond to a similar question in the following thread. Hope this helps!

When drilling down on a visual, can you control other visuals drill down level too?

Hello @sagmukhe, Your answer is very helpful, thank you! When I try to implement it on our Clustered Bar Combo Chart, I’m running into trouble because it appears to want to have a date value on the x axis. [image] The problem is, we want to display either Year, Quarter, Month, Week or Day values (which need to be converted to text first) on the x axis. Do you know of any way to do that? Thanks again!