Change the currency symbol

[cuongle]

How I can change the currency symbol from dolla ($) to pounds (£)

[Anonymous]

You must select a column first and go to modelling and then check the format if the format is currency you select the relevent currency. I can not see you can do in bulk.

[Anonymous]

Hi, I am trying to format a field "actuals" to currency in query editor. Unlike desktop, I don't see how to set the format for the field to currency. 

I am trying to do this in power query so that when I change my datasource, the measures based on that field don't lose its formatting.

Could anybody please help me with this?

[yachanagupta]

measure = IF([column name]>10000000,

format([column name]/10000000,"₹ ##0.0 Cr"),

if([column name]>100000,format([column name]/100000,"₹ ##.0 L"),[column name]))

[Georgia94]

How do you change the currency symbol on power BI online though?

[ashishrj]

Just a pictorial representation to what @Greg_Deckler said above !

Hope this helps!

[Greg_Deckler · Accepted solution]

In Desktop, in the model, on the Modeling tab, highlight the column or measure and in the ribbon in the Formatting area, use the $ drop down to change the format.

[shoeb1359]

I am not able to find symbol for AED (United Arab Emirates Dirham).Is there any work around for that?

Could you please help me.  

@Greg_Deckler

[yachanagupta]

in currency symbol there is also available 

[shoeb1359]

My requirment was different . Client wants his amount should appear like (Arab Emirates Dirham)
AED 3,00,000,00
AED 2,00,000,00

I have acheived this through custom format using below code by applying in Modeling Tab format option.
"AED" #,0.###############;#,0.############### -"AED";"AED" #,0.###############

In this you have to replace whatever Symbol or text you want to use.

[Amr-Rabea]

I have the same issue here, Could anyone advis.

[yachanagupta]

measure = IF([column name]>10000000,

format([column name]/10000000,"##0.0 Crد.إ"),

if([column name]>100000,format([column name]/100000,"##.0 Lد.إ"),[column name]))

[MaryF]

My tests suggest that it uses the currency symbol set within the measure. So if you change that to £ you should get what you need. Hope this works for you. 

[jessewysong]

Hello,

Can I ask what would cuase the options under the modeling tab to be greyed out? I know I have added the currency symbols before. I am using a measure that is (quantity ordered * price) and its set to decimal number as data type. Oddly using a simple card visual I can't use the modeling tab. I have tried creating my measure in both the query editor and the regular home tab. 

thanks!

[jessewysong]

im an idiot, never mind! Select the field in your table, dont click the visual.