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/2017 and 18/11/2017 (correct for Australia), but as soon as I publish, it switches to the US format of 9/3/2017 and 11/18/2017.

I've hunted around but cannot find how to correct this.

Your assistance will be appreciated.

Thanks, Mark.

 

 

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

8 Replies

    • 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