Is it possible to set a default currency format? It’s quite tedious to set it for all fields in a pivot table.

Hi @BFJonk , @JoseB-aws JoseB-aws’s here is the current way of doing this (however, it has to be done for each individual field). The option to adjust the default formatting settings has been tagged a feature request.

That’s awesome! Thank you so much, José. Still, I think it would be useful to be able to tell Quick Sight we work in EUR not $, for all Currencies. Bart.

@JoseB-aws This is helpful to know. Does it work for other numeric data as well?

As of today 31. Mar 2023 you can :slight_smile:

You mean : [image] BFJonk: tell Quick Sight we work in EUR not $, for all Currencies. ? Where do you specify that?

Hi Bart, you can specify it in the field settings: Choose “Show as: Currency” Then “Format: €1,234.57 Euro” You still have to do it field by field, but at least you doit on the field level on on every visual.

Thanks @Gabriel_R for posting this! :slight_smile: @BFJonk did Gabriel’s reply provide the solution you needed? Hope so! If so, could you help the community out by marking that reply as “Solution” (clicking the check box under the reply)? Thanks!

Hi Kristin, Did so. However, I might miss it, but to me the solution of Gabriel_R seems to to be the same as the one from JoseB-aws . (And still, I think it would be useful to be able to tell Quick Sight we work in EUR not $, for all Currencies).

Hi Kristin, That’s nice. Yesterday I noticed the same goes for Time Formats (over here, across the pond, we’re not used to AM/PM and prefer 24H as the standard). Hope that has been included! cheers, Bart.

Thanks for calling this out @BFJonk .

Default currency format

Q&A

JoseB-aws September 15, 2022, 4:19pm 2

HEllo @BFJonk ,
If you change it at field level it will always apply the same currency in all visuals:

BR,
JoseB

Topic		Replies	Views
More Currency Options and Global Default Currency Q&A feature-request , quick-sight , business-user	1	32	July 24, 2025
Change the default settings of a number field Q&A formatting , feature-request , quick-sight , Business-Intelligence-Engineer	4	74	April 7, 2025
System currency to apply to all currency fields in dashboard Q&A analysis , formatting , quick-sight , Business-Intelligence-Engineer	2	108	June 26, 2024
Formatting of Fields not working - Multiple Analysis Q&A formatting , quick-sight , Business-Intelligence-Engineer	5	215	May 21, 2025
Dynamic Prefix or other ways to enable multi-currency reporting Q&A formatting , quick-sight , Business-Intelligence-Engineer	2	182	October 31, 2024

Default currency format

Related topics