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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hualian
Regular Visitor

Wrong in blank?

Hi,

 

I would like to ask if any one has the same issue as i have now in one of my PBI report. The blank value shows "30/12/1899" instead of "Blank"?

 

In fact, in my pbix file, it shows "Blank".

 

If i publish the report into my own workspace, it also shows "Blank".

 

It seems only show wrongly in our team workspace.

 

What is wrong here?  I do have other reports in team workspace has "Blank" shows normally.

 

Could any one help?

 

Thank you!

4 REPLIES 4
v-xiaoyan-msft
Community Support
Community Support

Hi @Hualian ,

 

Here it is still recommended that you check your date column. 

As the column is date format, 0 will be converted to 1899/12/31.

Please check it again or  sample data without sensitive information  would help tremendously.

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Thanks for your reply. i still can not solve the issue.

 

The strange thing is, i worked on the pbix file in PBI desktop, the empty date shows BLANK.

If i publish the pbix to any PBI workspace, the empty date shows BLANK.

But when i publish it to PBI APP, the empty date shows 30/12/1899.

Why? and How to solve it?

Could you please guide?

Thank  you!

Hualian_1-1638304964243.png

 

 

Anonymous
Not applicable

If your date column has value as 0, then it will be displayed as 12/31/1899. 

 

However, blank should appear as blank. Please check your data.

Thanks

Raj

Hi Raj,

 

Thank you for the reply.

 

If my data is wrong, why in Desktop and my workspace the report shows correct? .... Therefore i think my data is correct. I attach the picture. Please have a look.  Thank you very much!

d787b496-c71c-465f-9bee-7f87da0fb414.png

from my workspace. the report shows OKfrom my workspace. the report shows OKfrom PBI desktop, the report shows correctfrom PBI desktop, the report shows correct

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors