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 to "Day name, Month Name, Day Number, Year". 

How do I retain the same date format?

Need Help

4 Replies

  • 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!
  • 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!