Forum Discussion
Converting Text to Date whilst processing for visualisation
Hi Shirley101,
To address the issue, please follow these steps:
First, convert the text-based month names into recognizable date values by creating a new column. Append a day and year to the month name to form a complete date (e.g., "01 January 2025"). Set the data type of this new column to Date to ensure proper recognition.
Next, update your visualizations and relationships to use this new date column instead of the original text-based month column. This will resolve the error and ensure your visual functions correctly.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Thank you.
Hi Shirley101,
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thankyou.
Hi Shirley101,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved. If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for using Microsoft Fabric Community Forum!