Can I customize the date value in the QuickSight line graph on the x axis?

By default Line X axis is showing the first day of the month. I want to display the last day of the Month on the X axis. I have already applied a filter to pull only the last day of the month but the X axis still shows the 01/XX/XX.**

Thank you for posting your question here. Are you aggregating your data by DAY or MONTH? If you use DAY, then the 1st DAY of the month will show. You can also try to change the date column data type to String.

Hi Xing, thanks for your response. Yes aggregating by day. let me try converting it to string.

Hi @RAHUL_singh1

It appears your date is aggregated by Month. If your issue is more how to display, than the computed value itself you could create a calculated field to calculate the Last Day of the month.

See a similar requirement below where the Week is being calculated. You could use the queue to get your last day of the month computed and use this calculated field in your line chart.

Regards,
Giri

1 Like

Hi @Giridhar.Prabhu , I tried but did not working because Y axis has a calculated file which pointing to date_formatted (X axis variable)

Hi @RAHUL_singh1

Was the original field used in the line chart date_formatted? If Yes, could you change it to the new calculated field for date?

Regards,
Giri

Hi @RAHUL_singh1,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @RAHUL_singh1,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!