cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chydewf1 Regular Visitor
Regular Visitor

Date Format differences between desktop and online

Hi,

 

I have some published report on power BI. The desktop app shows the date format in DD/MM/YYYY but when published the online versions show it in MM/DD/YYYY.

 

How can I correct this, I want both as DD/MM/YYYY?

 

Thanks

 

Chris

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Date Format differences between desktop and online

Hi @chydewf1

 

What I did was to change the PC I was working on to use the English Format for the Region Settings as shown below.

PBI Upload.png

 

And it is displaying fine in the Power BI Service, even with the Gateway refreshing the data.

 

PBI Upload.png

 

 

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
chydewf1 Regular Visitor
Regular Visitor

Re: Date Format differences between desktop and online

So I managed to get it to work. Once I signed in to chrome as a registered google user it allowed me to select english in the language setting and set it to default.

Thanks very much for the help
7 REPLIES 7
Moderator v-yuezhe-msft
Moderator

Re: Date Format differences between desktop and online

@chydewf1,

This is a known issue in Power BI Service, the dates are displayed in MM/DD/YYYY format by default. There are ideas about this issue, please vote them up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11698167-limitation-of-power-bi-o...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837330-english-uk-and-english-u...

In addition, to work around this issue, in the Power BI settings set the Language to: “Default (browser language)” and ensure the browser is set to “English (United Kingdom)”


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Date Format differences between desktop and online

Hi @chydewf1

 

What I did was to change the PC I was working on to use the English Format for the Region Settings as shown below.

PBI Upload.png

 

And it is displaying fine in the Power BI Service, even with the Gateway refreshing the data.

 

PBI Upload.png

 

 

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
chydewf1 Regular Visitor
Regular Visitor

Re: Date Format differences between desktop and online

Hi Thanks for the replies

 

The fix works well in internet explorer but I cannot get it to work in Chrome.

 

Does anyone have any ideas?

 

Thanks

 

Chris

Moderator v-yuezhe-msft
Moderator

Re: Date Format differences between desktop and online

@chydewf1,

I also can't get it work in Chrome. Since there is no existing option to change date format in Power BI Service, I am afraid that you need to use IE in this case.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Date Format differences between desktop and online

My screenshot was from Chrome
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
chydewf1 Regular Visitor
Regular Visitor

Re: Date Format differences between desktop and online

@GilbertQ

 

What version of windows and chrome are you running - I just can't seem to get it to match?

 

Thanks

 

Chris

chydewf1 Regular Visitor
Regular Visitor

Re: Date Format differences between desktop and online

So I managed to get it to work. Once I signed in to chrome as a registered google user it allowed me to select english in the language setting and set it to default.

Thanks very much for the help