Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
soldstatic
Resolver I
Resolver I

ESRI ArcGIS Visualization Time Field

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.

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @soldstatic,

 

Can you share a sample? Maybe you need a measure. Or you need to change the data structure.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sure the data looks like this (anonymized for the forum):

 

IDStart DateEnd DateStatusComp1LengthComp2CLatitudeLongitude
543571155/1/18 0:015/1/18 0:13CMP4712.41666667583.5833331914XY
543571165/1/18 0:095/1/18 0:13CNL14.654.651263XY
543571175/1/18 0:285/1/18 0:32CNL14.854.851263XY
543571185/1/18 1:045/1/18 15:25CMP0860.416666705332XY
543571195/1/18 1:265/1/18 1:33CNL17.2166666677.216666679141XY
543571205/1/18 1:385/1/18 1:59CNL121.3333333321.33333331263XY
543571215/1/18 1:555/1/18 1:59CNL14.3333333334.333333339141XY
543571225/1/18 2:145/1/18 2:37CNL123.923.91263XY
543571235/1/18 2:405/1/18 2:59CNL119.7166666719.716666712834XY
543571245/1/18 2:405/1/18 4:07CMP15087.4166666713112.512834XY
543571255/1/18 2:475/1/18 2:59CNL112.912.91263XY
543571265/1/18 2:535/1/18 3:00CNL16.76.7UNKNOWNXY

 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.