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 ...
Need Help
  • 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


Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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
    8 years ago

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

    Just M-language works. =/

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      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