Solved: Re: 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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!