Currency Format

[Anonymous]

Hi everyone, I wrote this code as a measure:

Moneda Seleccionada =

VAR CAMBIO = SELECTEDVALUE(Hoja4[SIGLAS])

RETURN

IF(CAMBIO="USD",

FORMAT([TOTAL USD],"$ #.##"),

IF(CAMBIO="PE",

"S/" & " " & FORMAT ( [TOTAL SOLES], "#.##" ),
FORMAT([TOTAL REALES],"R$ #,##")))

And I am trying yo see this information in a matrix but I cant get them line up to the right. As it is shown the total is on the left.

[DataInsights · Accepted solution]

@AlekseiNexa,set the array formatting options as shown below: