Help with historical vehicle movement graph based on time and zone

[Syndicate_Admin]

Hello, good day.

Could you help me with the chart below?

I am doing a project where I track vehicles using GPS through different areas of a company's facilities, displaying different statistics in a dashboard in Power BI. I was asked if it was possible to make a historical graph of the day that reflects the number of vehicles that were in certain areas of interest depending on the time.

Each area of interest has its own graph, for example in the parking lot I need to see something like this:

The idea is to establish time intervals, for example every 15 minutes where the number of vehicles present in the place is recorded and if in the same time interval a vehicle changes more than once it gives rise, consider it only in the last zone, so that each vehicle can only belong to one zone at a time in each time interval.

The data set used records each time the vehicle is detected in a new place, storing its ID, date, time and place of detection. The system must assume that the vehicle is kept in a certain area as long as there is no new registration that updates the area in which it is located.

I am currently unable to find a way to make this chart, so any feedback or solution is appreciated.

Best regards.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523