Format of a currency

[Pikachu-Power]

hi all,

for a card i have the measure with the presentation "234,2 Tsd."

I want to change it to "234,2 T€".

What would be the best way to do this?

Maybe some changes via Model and Format?

Thanks. 

[Syndicate_Admin]

"S/" & Format( [_ventas] , "#,##0" ) , Try to concatenate the currency sign you want first and then format it as a number with 0 decimal places. I had that problem but I wanted to put S/

[Syndicate_Admin]

Try copying the formatting from excel and paste it where the format is chosen in powerbi

this is my format that works for positives and negatives : UF #.##0 ;-UF #.##0

Answer somewhat late, I hope it will serve the community,

Best regards

[Pragati11]

HI @Pikachu-Power ,

When you click on your column you get following under FIELDS pane, you see under MODELLING tab:

Here you can modify to whichever currency you are looking for.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak]

@Pikachu-Power , under format you have option for Currency symbol

refer: https://medium.com/@vaishaligoilkar3322/power-bi-change-currency-symbol-using-card-7b023419f407

[Pikachu-Power]

hi,

@az38:

when i have 123.456 Tsd i get with format 123.432 T€. The point means here the thousand seperator. What I need is 123,4 T€

@amitchandak 

the site doesnt help. In german we have in the card Tsd. instead of K. I want to change it to T. In best case Mio. for milion should change in M. As far as I see there are no posibilites to change this in a card? 

So the currency is not the main problem. Something like to change K to T in your case.

[az38]

@Pikachu-Power 

it depends on localization, try

Formatted = format([YourMeasure], "#.## T€")

[Pikachu-Power]

hi az38,

It works with Formatted = format([YourMeasure]/1000, "#.# T€")

Then I have 123456 / 1000 = 123, 4 T€

But what if i have a million? 😅 Than i would get 12345,6 T€ instead of 12 Mio or 12 M.

[Pikachu-Power]

format( ) seems not to be the best solution. it convert the measure to a string and it is not flexibel when the number changes to million, thousand and hundret. are there maybe other tiles in the marketplace where you can change the abbreviation?

For example i want Mio. instead of M and so Tsd. istead of K in flexibel way.

[az38]

@Pikachu-Power 

try create a measure = 

Formatted = format([YourMeasure], "#,## T€")