Forum Discussion
Date Format
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?
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.
- Use the FORMAT DAX formula to enforce exact date rendering:
- Use the column formatting options from the modelling view.
3 Replies
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.
- Use the FORMAT DAX formula to enforce exact date rendering:
- Use the column formatting options from the modelling view.
The third option (Use the column formatting options from the modelling view) worked.
Thank you!
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.
