Set Currency Symbols for Visualizations

You can set measure values in a visualization to display an appropriate currency symbol.

You can configure a measure to use a custom currency to display the symbol associated with a currency. For example, if you set a canvas filter to display a European Ledger, then the Euro symbol is displayed for each measure value that's associated with the custom currency property. The workbook data must contain a currency code column, for example, a Ledger Currency column. The currency code column enables the display of an appropriate currency symbol for the measure column, for example, a Profit column.

1. On the Home page, hover over a workbook, click Actions, and then select Open.
2. In the Properties panel for a selected measure, click the Values tab, click Number Format, and select Currency.
3. In the Currency field, click the currently displayed value and select Custom.
4. In the Custom field, add the column that determines the currency code.
5. Click Save.

Tip: If you're your currency values are prefixed with country code and currency symbol in a Chrome browser, use the Languages settings in Chrome to set the Language value, which affects the format displayed in workbooks. For example, set the Language to "English (United States)" to prefix currency values with $ instead of US$.