Chart can't remove Time from date

[AmyS7]

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 chart display the date without time and with continuous type. Please help me!!!  Thank you in advance!

[Anonymous]

Pls, can you try removing the time part from the column and just use the date..?

Maybe create a new column that has only the data part and use that in your graph. I have not tried this but you can try it quickly. 

[Mikelytics · Accepted solution]

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