Wrong in blank?

[Anonymous]

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!

[Anonymous]

Hi @Anonymous ,

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.

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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!

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