Why a date column shows blank? Even in a data still show the date.

[Anonymous]

In the datatable, the date column show that all of the cells have value. But when I create line chart it show blank.

So, I check the date column with ISBLANK, it shows that only cells of 1/1/2022 are blank.

[Anonymous · Accepted solution]

I found that the problem is a regional settings. My first setup is Thai. Then, I chagned to English (United States), the Power BI can read it. Thank you for 

Options and Settings --> Options --> Regional Settings --> English (United States)

[PijushRoy]

Hi @Anonymous 

If you are using calender table, please check the Date
Issue looks some date are mismatch between DIM Calender table and FACT Data Table. Please check all date between both table 

If solved, mark as SOLUTION

[ryan_mayu]

where do you get the month like Jan Feb?

What does the date for other month look like?

[Anonymous]

Every months the date format show like Jan. But i don't know why it still blank only on 1/1/2022 (200K rows)

[ryan_mayu]

could you pls provide the pbix file?

[Anonymous]

Which channel would you prefer? My pbix is about 1.13M KB. I will trim them down before send to you. 

[ryan_mayu]

you can share via onedrive