Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove automatically added date from column

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 

  • Anonymous 

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

     

1 Reply

  • VijayP's avatar
    VijayP
    Community Champion

    Anonymous 

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