Fleet Tracking

Hi pykie80,

Thanks for reaching out in Microsoft Community Forum.

Please follow below to resolve the error;

1.Group the IVMS data by time intervals (e.g., hourly or 30-minute slots) to simplify large datasets in Power BI.

2.Use DAX measures to identify overlapping usage periods between vehicles (e.g., by comparing start and end times).

3.Create visuals like stacked bar charts for usage trends, heatmaps for concurrent usage, and a matrix table for time slot-based vehicle tracking with filters for Group, Registration, and Date.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.