Data Studio
1.5K members online now
1.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.