Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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.
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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |