Date Format

[BrunoMendes]

Hello,

I am trying to keep the date on my Report in Brazil's format (DD/MM/YYYY), but i don't know why it keeps changing to MM/DD/YYYY.

I have verified every Region Configuration and they are all to Brazil.

At first it stays on Brazil's format but after a while changes to MM/DD/YYYY.

Does anyone have solution for this? Is this related to the programmed update of the data?

[Tutu_in_YYC]

In addition to what @otravers mentioned, date format is also affected by your browser's (Chrome/Edge/Safari/Opera) regional/language settings. So you might have to configure that.

[otravers · Accepted solution]

Not sure how you're handling your dates or whether you're talking about implicit or explicit measures, so it's hard to say. Here are a few things that may help you:

- Apply a locale when you're ingesting date columns in Power Query. Typically you'd do this in your date dimension table.

https://support.microsoft.com/en-us/office/set-a-locale-or-region-for-data-power-query-d42b9390-1fff...

- Use the FORMAT DAX formula to enforce exact date rendering:

https://dax.guide/format/

- Use the column formatting options from the modelling view.

[BrunoMendes]

The third option (Use the column formatting options from the modelling view) worked.

Thank you!