Forum Discussion

chydewf1's avatar
chydewf1
Frequent Visitor
8 years ago
Solved

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 ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    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's avatar
    chydewf1
    8 years ago
    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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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=eyJrIjoiMDkwYmIwMmQtZjAxZC00ODY3LWFhMjEtODE0Y2JjOGQyY2I5IiwidCI6IjA0NWEwMTM0LWJlZWUtNDEzYy1hMjgyLWU1YjQ3MGY1NGJkMCIsImMiOjEwfQ%3D%3D

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's avatar
MatE
Frequent Visitor
6 years ago

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.