Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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.
I have no that options, because I'm using DirectQuery.
Just M-language works. =/
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |