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.
Hi!
How to change the date display format from MM/DD/YYYY to DD/MM/YYYY in power BI Service. The Date is in DD/MM/YYYY when I uploaded it from my .pbix file but in service it takes it as MM/DD/YYYY. How to change this.
Please do help out
With Regards
Agragesh
Hi @agragesh123,
I'm not able to reproduce the issue on my side. The DAX = Format([Date],"dd/MM/yyyy" ) will work fine in Power BI service.
In your scenario, please publish the attached .PBIX file to service to see if the issue persists.
Best Regards,
Qiuyun Yu
Please choose that field and navigate to Modeling tab, and choose options in Format
In case this feature could not adapt your expectation, you could use DAX with Format function:
_ Create New Calculated Column
_ New Column = Format([DateField],"dd/MM/yyyy" )
Otherwise, You should refer discussed topic for locale setting:
https://community.powerbi.com/t5/Desktop/How-to-change-the-date-format/td-p/40460
hi! @tringuyenminh92
I have tried both the methods suggested before. I guess Modelling Tab is avilable only in Power BI desktop and not in Service.
My desktop version is correctly displaying the date as DD/MM/YYYY but once I upload to service it changes to MM/DD/YYYY this is the problem.
Thanks
Regards
Agragesh
In this case, we could wait response from some staffs or you could post this in issue forum: http://community.powerbi.com/t5/Issues/idb-p/Issues
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.