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