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".

 

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!

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

      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

  • 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!