Advance Excel chart, scatter chart with multiple axis value with time lapse

Question

I have 7 different measurement points on which is temperature measured for every hour (timestamp). Like these pic down.

I want graph similar like these.

Data table:

timestamp               m1_temp m1_dist m2_dist m2_temp
Mar 9, 2017 12:00:00 AM 51.72   20.00   10.00   41.72
Mar 9, 2017 1:00:00 AM  48.73   20.00   10.00   38.73
Mar 9, 2017 2:00:00 AM  43.51   20.00   10.00   33.51

I get:

So problem is now: I need to pick timestamp range (button or just calendar with time) and see animation (not real animation, it would look like that because data ranges would change for example every 2 seconds) on chart trough that time. It would be great to see chart title as timestamp. Maybe connect points with line, it would be more visible to the viewer.

Thanks in advance

Answer 1

Currently, I don't think it's possible to have timelapse animation in Power BI visuals.

There is an idea related to this that you can vote on though: Animation for ALL!

Without animation, there are a couple possible ways to attempt a similar thing. Either use a slicer for time or else show all times at once.

To do this, your data will need to be formatted a bit differently like this: