Forum Discussion

Khushboobarai's avatar
Khushboobarai
Icon for Helper IV rankHelper IV
7 months ago
Solved

Currency Conversion from indian format to European format

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 ...
Need Help
  • Khushboobarai's avatar
    Khushboobarai
    6 months ago

    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's avatar
v-achippa
Icon for Community Support rankCommunity Support
7 months ago

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's avatar
Khushboobarai
Icon for Helper IV rankHelper IV
6 months ago

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's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    6 months ago

    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