Solved: date field unidentified

sam_nik12345 · ‎01-06-2022

My table looks below:

But not recognized as date field in visualization page.

Need help on this.

amitchandak · ‎01-06-2022

@sam_nik12345 , Check-in DAX they are marked as a Date field in column tools. Change the data type to something else and make it date again

This may be because Auto date time is switched off at global or at the file level

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎01-06-2022

@sam_nik12345 , Check-in DAX they are marked as a Date field in column tools. Change the data type to something else and make it date again

This may be because Auto date time is switched off at global or at the file level

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

sam_nik12345 · ‎01-06-2022

One date is identified as shown below but other as above is not.

date field unidentified

Helpful resources

Power BI Monthly Update - October 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - October 2024

How to Get Your Question Answered Quickly