Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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!
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!