Forum Discussion

Vicky2020's avatar
Vicky2020
Frequent Visitor
6 years ago

Date values incorrectly flagged as blank

Hi all,   I've encountered a weird issue and I can't figure out how to resolve it.   I'm trying to put together a line chart which tracks the volume of support requests my team had recieved in th...
Need Help
pminnov's avatar
pminnov
Icon for Helper II rankHelper II
1 year ago

I had the same problem working with live data being imported from Dynamics into Power BI. New dates added in Dynamics had a timestamp applied to them (whereas previous dates loaded into the sytem had 12:00:00 associated with them) and this caused the new dates to be treated as blank. The fix was to go into power query, select the column containing the dates (with the mixed timestamps) and change the format of the column from 'date/time' to 'date'. All the other columns in Power BI were also formated as date. After I made the format change Power BI no longer viewed the dates with different time stamps as blank. 

  • pminnov's avatar
    pminnov
    Icon for Helper II rankHelper II
    1 year ago

    I should add - you need to change the date format by selecting the column, right-clicking and then selecting 'change type'.