Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
5 years ago

date format in Service

Hello

When using a date visual in Desktop, dispays d/mm/yyyy but when I publish it, shows, m/dd/yyyy, any ideas why that is?

 

Thanks

Ross

Need Help

2 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    5 years ago

    Hi rosscortb ,

     

    There are a couple potential reasons for this that I know about.  One might be the computer's default settings for displaying dates.  Technically, this should not override the display in the report, but sometimes it does.  This can be particularly true though if the computer displaying the information has "accessibility" settings turned on.  The other computer option is that the computer is in another part of the world that reads dates that way.  My computer does this routinely (although not always).

     

    Another option is the browser itself - is this the same in all browsers on that computer?

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi rosscortb 

     

    Usually you could use Column tools -> Format to change how dates are displayed in the visuals on a report and they will keep the same format when published to Service. But when it is used in a slicer with Between/Before/After mode, it will not always be in the format as selected in Column tools.

     

    There is an idea about this which you may vote for https://ideas.powerbi.com/ideas/idea/?ideaid=259584ec-e3cd-441c-8380-6ccd88abc364 .

     

    Best Regards,

    Community Support Team _ Jing Zhang