Forum Discussion
Avonwood
10 years agoNew Member
Insightly Currency
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 ...
Greg_Deckler
10 years agoCommunity Champion
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
10 years agoNew Member
It is the service model i am using, but thanks for the reply.
- Greg_Deckler10 years agoCommunity Champion
You do not really have any capabilities to manipulate your data model in the Service.