Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
4 years ago

Published report displays different date format

I have a Power BI report on my dekstop with a card visual displaying the date. The date format is "Day number, Month Name, Year". However, when I publish the report to PBI Service, the format changes...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi bo_afk 

It may be caused by different date format .Please check the Regional Settings in Desktop and Language settings in Service , make sure they are consistent .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Prakashk's avatar
    Prakashk
    Regular Visitor
    3 years ago

    This works, But is it expected that every user makes necessary changes in their browser to see the date in the correct format?

     

    Hopefully, there is a better way to manage this.

     

    Regards,

    • aybarsacar's avatar
      aybarsacar
      Frequent Visitor
      3 years ago

      As the dashboards have many different users and can't manage their personal preferences on their browsers, I have found it more useful to hard code the date format where I show dates with the following dax as an example:

       
      ```
      FORMAT( MAX(MD4C[CopyActivityDateTime]), "mm/dd/yyyy", "en-GB" )
      ```
       
      cheers!