Default Power BI Desktop to Pound Sterling not USD

[GarryPope]

Hello Power BI Community,

I hope you can help please.
Whenever I use Power BI Desktop the currency is always USD not Pound Sterling, and I have to change every every column to show Pound Sterling. 

Is there a setting to default to Pound Sterling rather than USD at either the entire Power BI Desktop level or else at the entire Report level?

Thanks very much,

Garry

[GarryPope]

@speedramps thanks so much. Shame I can't set a default currency for the entire file. Have a good one.

[speedramps · Accepted solution]

Hi Garru

In Power Bi when you edit a query table and click on column and Change Type= Fixed Decimal

then the column heading will show $ to the left of the field name.

This does not mean dollars, it means that the data type is currency.
A field "data type" is how data is stored, not displayed.

You need to change the field "format" to alter how it is displayed.

If you then go into modelling mode and click on the value column, 

under the Format dropdown, click on the $ dropdown and select £ English (United Kingdom).

Now when you drag and drop that field on a Table, Matric, Card or graph visual it will appear as £s.

It is best pratice to set all fields to the correct "data type" and "format" before creating any visuals.

I am an unpaid power BI volunteer.  Please click the thumbs up and/or click solved of you like me helping you.