Hi I have a column consisting of due dates, but it is in text format. How can I switch it into a date format on power bi?
It will not let me simply just change the data type into a date. Thank you.
Hi @abeirne
In Power Query, select that column and set the DATA TYPE to DATE. Make sure the format of your date is dd/mm/yyyy, otherwise you will face with error.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @abeirne
In Power Query, select that column and set the DATA TYPE to DATE. Make sure the format of your date is dd/mm/yyyy, otherwise you will face with error.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
