Forum Discussion

raphael_moreira's avatar
raphael_moreira
Frequent Visitor
8 years ago
Solved

Date formatting does not work

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?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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


3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
      raphael_moreira
      Frequent Visitor

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

      Just M-language works. =/

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee

        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