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

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