Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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"....
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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!