Formatting Date in Title and Sub Title

Q&A
,
1

I am having a visual, where i have a added a parameter of type Date like below

image
image568×644 27.6 KB

When i use this parameter in Sub Title of visual, it is displayed as “2024-06-30”
Is there any way to format it.
I want to format it like in finnish language. “30.06.2024”
Is there any way to do this?

2

Yes, you can format the date displayed in the subtitle of a visual in Amazon Quick Sight. Here’s how you can do it:

  1. In the Quick Sight visual editor, locate the visual where you want to format the date in the subtitle.
  2. Click on the visual to select it, then click on the “Format” tab in the right-hand panel.
  3. In the “Subtitle” section, you should see the date field that is currently being used. Click on the date field to open the format options.
  4. In the format options, you’ll see a “Custom” format option. Click on this, and you can then enter the desired date format.

For the Finnish date format “30.06.2024”, you can use the following custom format:

dd.MM.yyyy

After entering this custom format, the date in the subtitle should now be displayed in the desired Finnish format.

Alternatively, you can also use pre-defined date formats in Quick Sight. For the Finnish date format, you can select the “Finnish (Finland)” option from the “Locale” dropdown, and the date will be displayed in the correct format.

Remember that the date formatting options may vary depending on the version of Quick Sight you’re using, as Amazon may introduce new formatting options over time. Always check the available options in the latest version of Quick Sight.

3

I am having below options when selecting subtitle

image
image907×571 23.5 KB

With finnish settings also it appeared same.
image

image

4

You can try moving the Visual to a paginated report sheet, and using a text box in the header with the desired print date format.

1 Like
5

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!