Currency Conversion from indian format to European format

[Khushboobarai]

Hii,Can someone pls help me with my sales column which I imported form the excel, and in that rwa file it was just in General format, but in power bi, i want it to convert into european decimal value , in my case i have tried changing the regional setting as German(germany) and even treid in the power query to change my data type using local and then german(germany), Then in power bi i tried changing with the currency too but what happens is it gave me only euro sign. 
Only Euro sign but no change is the decimal or thousand seprator 
as from the ss 

1st value supposed to be 1.000.000,00 but it gave as in Indian format pls help

[v-achippa]

Hi @Khushboobarai,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @cengizhanarslan and @danextian for the prompt response. 

Here the value is already correctly imported as a numeric value. Indian or European separators are only display formats, not different numeric values.
Change Type --> Using Locale only works when converting text to number, so it has no effect here. To get european separators, you must set the report or model regional settings to a european locale for example like German (Germany) and then restart power bi.
Power bi does not support changing thousand or decimal separators per column or per visual.

Thanks and regards,

Anjan Kumar Chippa

[Khushboobarai · Accepted solution]

Both method not worked for me, so I had to changes my overall windows setting that way only i could do it.
Thank You

[v-achippa]

Hi @Khushboobarai,

Thank you for the response and confirming that the issue is resolved. Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[danextian]

I've tried this several times. I changed the culture and all but the separators (comma and period) did not interchange. 

[cengizhanarslan]

• Go to Power Query Editor

• Select the Sales column

• Change Type → Using Locale

• Set:

  • Data Type: Decimal Number

  • Locale: English (India)

[Khushboobarai]

yeah, as mentioned above in my question, I already treid this way too.