Forum Discussion

Khushboobarai's avatar
Khushboobarai
Icon for Helper V rankHelper V
8 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 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

 
Need Help
  • Khushboobarai's avatar
    Khushboobarai
    8 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

6 Replies

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    8 months ago

     

    • Go to Power Query Editor

    • Select the Sales column

    • Change Type → Using Locale

    • Set:

      • Data Type: Decimal Number

      • Locale: English (India)
    • Khushboobarai's avatar
      Khushboobarai
      Icon for Helper V rankHelper V
      8 months ago

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

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    8 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 V rankHelper V
      8 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 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's avatar
    danextian
    Icon for Super User rankSuper User
    8 months ago

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