How to make $9,123 change to 9,123 ?

[admin11]

Hi All

I have a CSV file , after import to PBI , the Amount field = text field , and the value label all come with $ sign , can some one share with me how to remove the $ sign ?

https://www.dropbox.com/s/wr1x6w2bjgmaxtj/CRM_TS_10.csv?dl=0

Above link is my PBI file.

Remark :- 

- I have try to load by folder sharepoint , due to dollar sign , i cannot using change Type to convert the field to whole number. For my application i must load by sharpoint folder.

- I lost have try to using PQ , by click on advance edit , and replace Text to Currency.Type it also fail to work. 

Paul Yeo

[ryan_mayu · Accepted solution]

@admin11 

in PQ replace value