cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Skemaz
Advocate II
Advocate II

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.

Picture.jpg

 

 

1 ACCEPTED SOLUTION

@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

View solution in original post

7 REPLIES 7
Phil_Seamark
Microsoft
Microsoft

HI @Skemaz

 

This issue sounds similar which has been solved

 

https://community.powerbi.com/t5/Desktop/Date-format-changing-desktop-to-web/td-p/117204

 

Let me know how you get on.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.

Picture.jpg

 

 

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi

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

Any assistance will be appreciated.

Thanks, Mark.

@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

View solution in original post

Many thanks. Problem solved 🙂

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.Picture2.jpg

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.