Forum Discussion

metricsman's avatar
metricsman
Helper I
9 years ago
Solved

Date format changing desktop to web

I have a dashboard that when publishing to web the format of the date in the slider changes.    Example on desktop:   The date is in "uk' format, DD/MM/YYYY   but when published the same ...
Need Help
  • JonBaylis's avatar
    JonBaylis
    9 years ago

    CC: WillT 

     

    Hi all,

     

    Fixed it!!!! - Well my DBA colleague found the solution.

     

    The reason it was working for some users and not others is the following:

     

    When a user had their default language set to English UK then their language setting in Power BI would remain unset.
    When a user had their default language set to English US then their language setting in Power BI would get set to English.


    (This is why we had some users working properly)

     

    There appears to have been an update on the Power BI Service recently that allows you to set the language setting to respect the browser settings again.


    (This was not the case earlier this year http://community.powerbi.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-English/td-p/126262 )


    This means, you can now correct your language in your browser and then setting the Power BI Service language to default and the issue should be fixed.

     

    To do this:

     

    Change your browser language to English (UK) (or relevant language).

     

    IE: Set IE Default Language (same for IE 11)

     

    Chrome: Set Chrome Default Language


    Then, in the Power BI Service, under Settings > Language, set it to Default (browser language).

     

    Choosing this means the dates in my reports are now in the correct format, DD/MM/YYYY. :smileyhappy:

     

    Thanks,
    Jon

     

    Twitter: @JonBaylis

Anonymous's avatar
Anonymous
Not applicable
7 years ago

THIS IS ABSURD!!! How can the browser language define the date format being loaded via gateway??? :smileymad:

My project is pt-BR, DD/MM/YYYY, but I share with a branch in China, thus the Power BI Service must be in English, which is MM/DD/YYYY. I cannot lock my browser and PBI Service in pt-BR, but my data must stay DD/MM/YYYY as it is in my pbix! :smileymad::smileymad::smileymad::smileymad::smileymad::smileymad::smileymad:

julieTE's avatar
julieTE
Helper I
7 years ago

Hi , I'm sorry I don't find a solution despite any of your messages.

On my Desktop the date format is correct (ddmmyyyy) but on the webservice it becomes mmddyyyy, independantly from my regional settings, language etc.

On my computer regional language is French, on google chrome it is french as well, on PBI webservice it is set as default browser settings.

If I insert the ?language in the url it translates the interface but does not interfere with my date format.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yes, I'm still having the issue in both IE and Chrome. I've set the browser language to UK, set the language in the Power BI portal to Default(Browser) but it is still showing US format rather than UK.

     

    Help please :(