Published report displays different date format

[bo_afk]

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?

[aybarsacar]

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!

[v-yetao1-msft]

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]

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]

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!