Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
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
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |