Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |