Date Format differences between desktop and online

[chydewf1]

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

[GilbertQ · Accepted solution]

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.

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

[GilbertQ · Accepted solution]

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.

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

[chydewf1]

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

[v-yuezhe-msft]

@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

[GilbertQ]

My screenshot was from Chrome

[chydewf1]

@GilbertQ

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

Thanks

Chris

[chydewf1 · Accepted solution]

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

[andrmh]

Having this issue myself, managed to replicate the different displays in chrome and IE.....

I was able to partially resolve the issue, by ensuring ALL dates displayed in any report are formatted using a format option without the asterisk. Yes, this is more rigid, and will not be ideal if your audience is multi-national.

However, if your report is for a domestic audience only, then this shouldnt present any issues.

Note: I said i had partially resolved the issue.

It appears that a date slicer formatted to display as a range selection

Does not appear to behave itself.

In PBI Desktop this displays as above

In IE:

And in chrome:

Im still looking to see what my options are, but i suspect the filter visual - in this layout/format has a bug or limitation thats causing issue.

Hope this helps.

Andrew

EDIT:
Heres a simple test report i knocked together
https://app.powerbi.com/view?r=eyJrIjoiMDkwYmIwMmQtZjAxZC00ODY3LWFhMjEtODE0Y2JjOGQyY2I5IiwidCI6IjA0N...

if you run it in chrome vs IE you see different results in the table, however all the date slicers maintain the English-US date format.

[MatE]

If you're using Chrome as the browser for the power BI service, change the default language settings. 

Settings -> Dafault browser -> Language -> Select English (Australia) or (UK) as your default language. 

[v-yuezhe-msft]

@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