Forum Discussion

AmyS7's avatar
AmyS7
New Member
3 years ago
Solved

Chart can't remove Time from date

Hi all,   I want to remove time from date, I have searched some solution, such as change Continuous to Categorical. But it doesn't display the date with no data.      I need the char...
  • Mikelytics's avatar
    3 years ago

    Hi AmyS7 

     

    Do you need the time in general? If not, you can change the date type in power Query.  Then you do not have a time in your field.

     

    If you still need the time then I recommend you to create a custom column where you transform the value of the Date/Time column into a date column. Then you can use this column in your analysis.

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

    -----------------------------------------------------

    LinkedIn