Insightly Currency

[Avonwood]

Hello I am a new user to Power Bi. I am looking to improve the graphical representation of the data from the CRM system Insightly.  I have linked BI and Insightly and can see my data the one problem I am having is that all my figures are showing in Dollars and not GBP as they should be. Ive contacted Insightly they say this is a BI issue. Ive had a good look at the settings and been through the forums but cannot see an answer that fits. 

[Greg_Deckler]

@Avonwood - Not sure if this is for Desktop or Service as your forum choice was probably not the one that you wanted. In Desktop, make sure that the column in your data model is set to a number (Modeling tab, Data type). Then for Format, choose Currency and then the currency format that you desire. If you are in the Service only, you do not have the same level of control over the data model.

[Avonwood]

It is the service model i am using, but thanks for the reply.

[Greg_Deckler]

You do not really have any capabilities to manipulate your data model in the Service.