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

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
6 months ago

If your source is dd/mm/yyyy, don’t use English (US). Use English (United Kingdom-or other depending on your need) (or another dd/mm culture).

  • In Power Query: right-click the column → Change Type → Using Locale… → Type = Date, Locale = English (United Kingdom).

Or hard-code it (most deterministic):

= Table.TransformColumns(
    #"Previous Step",
    {{"Won/Lost Date", each Date.FromText(_, "en-GB"), type date}}
)