Forum Discussion

Skemaz's avatar
Skemaz
Advocate II
8 years ago
Solved

Problem with Regional Settings

Hi If you check out the 2 screenshots below, the one at the top is what I see in www.powerbi.com and the one below that is what I see in the Desktop Power BI. So when in the Desktop, I see 3/09/201...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    8 years ago

    Skemaz,

     

    Please format your date by using the DAX.
    Column 2 = FORMAT(Sheet1[Date],"D/MM/YYYY")

    And then publish it to Power BI services to check if the date format change or not.

     

    Regards,

    Charlie Liao

Skemaz's avatar
Skemaz
Advocate II
8 years ago

Hi Phil

Thanks for assisting, however the solution you refered me to doesn't seem to make a difference.

These are the steps I took (see screen-shots below).

(1) I checked and my powerbi.com settings and it was already set to "Default".

(2) In Firefox (checked in Edge as well), I removed English US leaving just English.

(3) I restarted Firefox and logged ina again but I still see the US date format.

I appreciate your assistance.

Cheers, Mark.

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi Skemaz

 

I'm in New Zealand so would have the same problem.  But when I publish to the web service the date ranges are in a format we would prefer (dd/mm/yyyy).

 

I'm using Explorer and Chrome

  • Skemaz's avatar
    Skemaz
    Advocate II
    8 years ago

    Hi Phil

    I'm in Bali and my Regional Settings (see below) are set to Australia and my users are in South Africa - so we all use dd/mm/yy format.

    Users in SA, Bali and Australia all report seeing mm/dd/yy.

    It's got me stumped becuase it looks great until I publish. 

    Thanks, Mark.

     

     

  • Skemaz's avatar
    Skemaz
    Advocate II
    8 years ago

    Hi

    I'm still tryig to find a solution (see my latest update.

    Any assistance will be appreciated.

    Thanks, Mark.

    • v-caliao-msft's avatar
      v-caliao-msft
      Microsoft Employee
      8 years ago

      Skemaz,

       

      Please format your date by using the DAX.
      Column 2 = FORMAT(Sheet1[Date],"D/MM/YYYY")

      And then publish it to Power BI services to check if the date format change or not.

       

      Regards,

      Charlie Liao

      • Skemaz's avatar
        Skemaz
        Advocate II
        8 years ago

        Many thanks. Problem solved :-)