Forum Discussion

ManchevB's avatar
ManchevB
Icon for Helper II rankHelper II
6 months ago
Solved

Possible Localization issue

Hello everyone,   a colleague from Belgium and I are working on a Power BI report that uses Excel files stored on SharePoint. In one of the data sources, we have a table containing a Won/Lost date...
Need Help
  • v-dineshya's avatar
    v-dineshya
    6 months ago

    Hi ManchevB ,

    I tried from end with sample data. It is working fine. Please refer below snap.

     

     

    It appears this issue might require deeper investigation from the Microsoft  Fabric support team. I recommend opening a Microsoft support ticket so they can trace the issue. To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    Regards,

    Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
6 months ago

Hi ManchevB ,

Thank you for reaching out to the Microsoft Community Forum.

 

Please try below workarounds.

 

1.  Please enable below settings.

 

File --> Options and Settings --> Options --> Regional Settings --> English (United States)

 

 

2.   Please replace your type conversion with below explicit M code.

 

#"Converted with Locale" =
Table.TransformColumnTypes(
PreviousStep,
{{"Incremental Value", type number}},
"en-US"
)

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
6 months ago

Hi ManchevB ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

  • ManchevB's avatar
    ManchevB
    Icon for Helper II rankHelper II
    6 months ago

    We tried as you recomended and still my colleague is seeing the wrong numbers. As soon as he opens the report and does a refresh, the format changes.. . 

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      6 months ago

      Hi ManchevB ,

      I tried from end with sample data. It is working fine. Please refer below snap.

       

       

      It appears this issue might require deeper investigation from the Microsoft  Fabric support team. I recommend opening a Microsoft support ticket so they can trace the issue. To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

      How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

       

      Regards,

      Dinesh

      • ManchevB's avatar
        ManchevB
        Icon for Helper II rankHelper II
        6 months ago

        Hi v-dineshya thanks for the guidance, I will look into that option.