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

dan_duluard's avatar
dan_duluard
Regular Visitor
5 years ago

This issue hasn't affected us until last week - early June 2021. Anyone else having trouble with date slider on Power Bi Server showing US-formatted mm/dd/yyyy dates instead of the UK-formatted dd/mm/yyyy ones I have formatted in Desktop?
I've double-checked data/date formats, toggling between types. Also tried browser language settings and Power Bi Region settings, all to no avail.
   To be clear it only affects the slider/'Between' view of a date filter. Other views (eg Dropdown, List, etc) are OK and retain UK dd/mm/yyyy formatting from desktop to server.
   This feels like a reoccurence of the old problems shown in this chat from 2018/2017 and wondering if a recent update has caused it? Any clues, ideas, similar recent experiences all gratefully received.
Thanks

  • Charlene-SA's avatar
    Charlene-SA
    Frequent Visitor
    5 years ago

    This is happening to me now, I thought it was just the browser had reverted back to US but ran through the steps changed language settings in Chrome to English UK then in Power Bi to browser default, this did not work so reset my browser to original settings and did the steps again. Still no joy some pages are UK but some are still US. Please help!