When importing my data it has identified my date field as a text field. The option to transform my data from text to date seems to be greyed out and as a result my trend lines are not working correctly (alphabetical rather than chronological.)
Any idea how to fix this/why this is happening?
Hi @newuser101 ,
If the "Month" and "Year" are separate columns, it will show as "text" and "whole number" in Power BI Desktop. And you can't convert them into a DATE type or use FORMAT function to change the type. It may show an "error".
If you have at least two parameters such as month-year, you can convert it to DATE type.
You can reference the following document.
Data types in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @newuser101 ,
If the "Month" and "Year" are separate columns, it will show as "text" and "whole number" in Power BI Desktop. And you can't convert them into a DATE type or use FORMAT function to change the type. It may show an "error".
If you have at least two parameters such as month-year, you can convert it to DATE type.
You can reference the following document.
Data types in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Can you check whether the datatype is set to "whole number"? This could be the issue.
Best regards,
Tim
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
