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
8 years ago

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's avatar
GilbertQ
Super User
8 years ago
My screenshot was from Chrome
  • chydewf1's avatar
    chydewf1
    Frequent Visitor
    8 years ago

    GilbertQ

     

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

     

    Thanks

     

    Chris

    • chydewf1's avatar
      chydewf1
      Frequent Visitor
      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.