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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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