Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

0 Value from Date Column Result 12/31/1899

Dear Team

 

Need urgent Help

Let say, i have an excel with column name 'FREE TIME END" contain of date value .

i got this value from vlookup from another workbook.

if workbook target has no value , mean result "0"

easy to hide 0 as blank on excel .

 

After i GetData from my Excel with FREE TIME END , all "0" value return to 12/31/1899

also i cant to change data type from "text" to "date" format

what i need to do ?

this is my excel view

My ExcelMy Excel

And below my powerbi data view

My PowerbiMy Powerbi

 

How do i eliminate all 12/31/1899 as blank .

 

Thanks

syaiful

 

 

1 ACCEPTED SOLUTION
Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Try using the replace value in power query editor to replace the unwanted dates with blank

 

awdawd.PNG

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi there - 

 

Can you please share the input file? I tried to create an input file similar to yours but I am able to get the data correctly in PowerBI.

 

Regards

Eswar

Anonymous
Not applicable

I too, was unable to get the data to display 'Incorrectly' in Power BI.  As Eswar suggests, this may be to do with your input.

 

FreeTime.PNG

 

regards, Sduffy

Anonymous
Not applicable

Hi syaiful,

 

Just as an afterthought... can you please check the following?

 

In PowerBI desktop, go to File --> Options and Settings, Then to "Current File" --> Regional Settings - Check what do you have selected for "Locale for Import", if this matches to the same locale for your Excel file, well and good, otherwise I think you need to change this in order to get the same date format as you have in Excel to start with. Hope this helps. Once I have the sample Excel file from you, that may help a bit more to check it out.

 

Regards

E

Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Try using the replace value in power query editor to replace the unwanted dates with blank

 

awdawd.PNG

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.