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,

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-online-compared-to-deskto
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837330-english-uk-and-english-us-options-for-powerbi

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