Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm using the ESRI ArcGIS visualization, and it's pretty neat! I love the fact that it has a time field, which is great to show how data plays out over time. My problem is that my data has a Start Date/Time and an End Date/Time. How do I create some sort of 'Active Date/Time"?
Basically if something starts at 7AM, and ends at 10AM, I would want that point to be displaying for hours 7, 8, 9, and 10 AM but to disappear afterwards. Currently it is only showing me data based on the single start date/time field, so it will only show it at 7AM and then it immediately disappears.
Hi @soldstatic,
Can you share a sample? Maybe you need a measure. Or you need to change the data structure.
Best Regards,
Dale
Sure the data looks like this (anonymized for the forum):
ID | Start Date | End Date | Status | Comp1 | Length | Comp2 | C | Latitude | Longitude |
54357115 | 5/1/18 0:01 | 5/1/18 0:13 | CMP | 47 | 12.41666667 | 583.583333 | 1914 | X | Y |
54357116 | 5/1/18 0:09 | 5/1/18 0:13 | CNL | 1 | 4.65 | 4.65 | 1263 | X | Y |
54357117 | 5/1/18 0:28 | 5/1/18 0:32 | CNL | 1 | 4.85 | 4.85 | 1263 | X | Y |
54357118 | 5/1/18 1:04 | 5/1/18 15:25 | CMP | 0 | 860.4166667 | 0 | 5332 | X | Y |
54357119 | 5/1/18 1:26 | 5/1/18 1:33 | CNL | 1 | 7.216666667 | 7.21666667 | 9141 | X | Y |
54357120 | 5/1/18 1:38 | 5/1/18 1:59 | CNL | 1 | 21.33333333 | 21.3333333 | 1263 | X | Y |
54357121 | 5/1/18 1:55 | 5/1/18 1:59 | CNL | 1 | 4.333333333 | 4.33333333 | 9141 | X | Y |
54357122 | 5/1/18 2:14 | 5/1/18 2:37 | CNL | 1 | 23.9 | 23.9 | 1263 | X | Y |
54357123 | 5/1/18 2:40 | 5/1/18 2:59 | CNL | 1 | 19.71666667 | 19.7166667 | 12834 | X | Y |
54357124 | 5/1/18 2:40 | 5/1/18 4:07 | CMP | 150 | 87.41666667 | 13112.5 | 12834 | X | Y |
54357125 | 5/1/18 2:47 | 5/1/18 2:59 | CNL | 1 | 12.9 | 12.9 | 1263 | X | Y |
54357126 | 5/1/18 2:53 | 5/1/18 3:00 | CNL | 1 | 6.7 | 6.7 | UNKNOWN | X | Y |
This is just a sample but events are about two hours long, but it varies drastically. I'd like this to look like one of those weather gifs where the animation plays out the series of events over time, but it currently only shows the data during the time frame when the events begin. It doesn't take into account the time that the events are restored.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |