CODEWITHSUNDEEP
excelchartspowerbipowerviewtimelapse
ejovrh2
ejovrh2

Reputation: 59

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

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

7 measurement points

I want graph similar like these.

GIF, these is what i want

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: enter image description here

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

Upvotes: 0

Views: 285

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40244

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.

Timelapse

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

Data Shape

Upvotes: 0

Related Questions