Remove automatically added date from column

[Anonymous]

Hello everyone 

I am facing this problem with my dashboard.  I have imported my excel spreadsheet into PowerBI, there is a column with Time , where I have different formats like " 19:00 - 23:00 "  ,  " 19:00 " or " all day " .  This seems to work fine in Excel, the column being set up to General. 

In PowerBi for some reason it adds a random date for some reason.  

Photos attached.

Excel :

PowerBi : 

It is set automatically as " Text " in powerBI , however I tried setting it to Time , it doesn't let me , that's probably because some values are set at " all day " instead of a number.

Anyway, any thoughts on how to set this on some sort of general formatting so it will not mess it up ? 

Thank you 

[VijayP · Accepted solution]

@Anonymous 

Change the Data type in Power Query instead of in the Report View