Forum Discussion
Solved
Why does Line Chart still show datetime when I already extracted time by changing Data type
I have a column of Date/Time type. I want to extract the time to use in Line Chart. Method 1 I duplicated the column with Date/Time type, then changed Data type to Time under Column Tools -> Str...
gitgithan There is no date or time data type in DAX, only datetime. DAX Data types – DAX Guide
I ran an experiment. If you have a datetime field and switch it to time you see only the time. If you switch it back to datetime, still only the time. But if you switch it to date, then you see the original date, so the original date is still there from the looks of it.
Greg_Deckler
Community Champion
Community Championgitgithan You're just changing the format, not the data type. If you just want the time you can do something like:
Column = [Column] - INT([Column])
Format it as Time and should be good to go.