Date formatting does not work

[raphael_moreira]

Hello.

This is bothering me:

I've read all the topics about date formatting (forum), and I do not know why, none of them work.

My scenery: DirectQuery > View > PowerBI

The date format is always in MM/DD/YYYY (english)

What I've Done:
- My Power BI software is in Portuguese (Brazil);
- I have already changed the PowerBI regional (File> Options> Regional Settings) to Brazil;
- I've already right clicked the Data column and changed the type to Regional Brazil;
- I've already tried using M-language (Date.toText (date, "DD/MM/YYYY"));
- I've already tried to separate the date into 3 parts and put it together in the correct order;

- I've already tried turning the column into the advanced editor like this:

     = Table.TransformColumnTypes (# "Column Added", {{"My Column", type date}}, "pt-BR")

Every time I convert the column to date, it returns to MM/DD/ YYYY, and days name in english.

And I need it to be DD/MM/YYYY

Can someone give a light?

[Greg_Deckler]

In the Modeling tab in the data model have do you have an option for DD/MM/YYYY? 

I don't believe you could create a new column if you are in DirectQuery and use FORMAT DAX command.

[raphael_moreira]

I have no that options, because I'm using DirectQuery.

Just M-language works. =/

[v-huizhn-msft · Accepted solution]

Hi @raphael_moreira,

What's your computer system Brazil or English? In Power BI Desktop, it will identify your data based on the regional setting of Power BI when you get data. While when you disply the data in report, it always change based on windows regional setting. 

Best Regards,
Angelia