error in transforming date field

Mohsen_2020 , if you have date in dd/mm/yyyy format, use this

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

 

 

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

Hi Mohsen_2020 ,

 

You may go to Add column in Query Editor, create custom column like codes below.

 

 

=DateTime.ToText(DateTime.From([Date]), "dd/mm/yyyy")

 

 

Or you may go to File ->Options and settings ->Option-> Global, enable this type detection option like below,  restart the Power BI Desktop to take effect this change, and then reopen your pbix file.

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi  Mohsen_2020  ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy