AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5K members online now
5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

is it possible to format a currency value in a table?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

I have currency values in a table in Data Studio and they long format (including decimals). 

 

is there a way to format those values?

 

Thank you. 

is it possible to format a currency value in a table?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Do you want to round the decimal places?

is it possible to format a currency value in a table?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Louis, 

as a minimum yes, 

ideally, I would use a compact numbers version like in scorecards.

Thank you, 

Elmer

is it possible to format a currency value in a table?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

gotcha, I don't think that's possible at the moment.

 

The most compact you can get the number (as far as I can tell) is to make a calculated metric using the round function, so for example:
ROUND(Revenue, 0) - this will round revenue to 0 decimal places. If you then set it as numeric rather than currency it will display revenue as, for example:

24,876 rather than $24,876.34.

 

Not ideal I know.... I would be interested to see if there is a better way!

 

is it possible to format a currency value in a table?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Thanks Louis, I was wondering the same thing.