Visual stopped displaying certain datapoint

[Anonymous]

Hello, 

Oddly enough my powerbi report's visual stopped displaying a certain datapoint. 

More specifically i'm talking about the first datapoint of this table (datetime = 5:15:01): 

I'm using this data in two visuals: 

1) calculates running total 

2) calculates amount of records / hour

As you can see the second visual starts plotting at 5:15:01, however the first one doesn't. 

And I don't see any difference in the way my formula is built / filters that I have applied. 

Also, about a week ago this used to still work (This is the same visual as 1) but pinned to a dahsboard): 

Could this have anything to do with powerbi updates?

And would anyone know any fix for this? 

Thank you. 

Vincent

[Anonymous · Accepted solution]

I found the solution for this entire problem. Underlyingy, the first record had milliseconds .9762000. Powerbi was unable to use this in it's calculations. After I changed the milliseconds to zero everything behaved normally again. 

Issue solved 

[kumar27]

That is beacuse of the data and the modeling that has been done , 

The FK of the table ties  up with the PK like a left join resulting in blank  value.

you can get rid of this by removing/ deselecting BLANK from filter pane. 

[Anonymous]

Hello, 

I was able to fix this by adding 0 to every record, seems like first 0 was converted to blank for some reason. 

However I still have one problem. Next to the running total we also want to display a target for every datapoint, which would be 300 records every hour. 

The current data and formula looks like this: 

What I don't understand, and don't want, is that those first two 0 records. 
Does anyone know why this formula doesn't start calculating the target immediately? 

Thank you.

Kind regards,

Vincent