DateTime Issue: Urgent

I have a date column(transaction date) in my sales table in datetime, i created a replica of the table using this
ref = Date.FromText(Text.From([debitrequestdate])). it converted it to mm/dd/yyyy, the problem i have now is that when i put it my result in a chart it shows date & time.

Please I need to eliminate the time showing in the chart



You should be able to just select your RefDate column and then on the ribbon select Modelling----change the data type and format as you require.

If this doesn’t work please share a copy of the PBIX file and i will take a look.


Hi @Phaniey, we’ve noticed that no response has been received from you since January 17, 2020. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!