An Overview Of Power BI Route Map Visual

Introduction

  • Power BI Route Map Visual is used to define the track of traveling objects on a map.
  • We can achieve this visualization by connecting the data containing fields like date time, latitude and longitude of the route, start and destination location and route sequence.
  • Using this feature, we can also define the status of traveling objects like truck or car, its completed route, and pending route as well.

Where to use Route Map Visual in Power BI Report

  • If you are designing an analytical report for traveling, delivery, or transportation kinds of subjects, you will have to consider the following points for insights.

    • How many orders are delivered successfully?
    • What is the status of dispatched or On-the-way orders?
    • Where are delivery vehicles right now?

This kind of insights we can show on the map in a user-friendly way using the Route Map Visual.

  • This visual can be useful in explaining the route using animation as well.

Example

Connect Data to visual

You will need the data in the following format.

LatitudeLongitudeStatusTrackIDDateTime
32.71094-117.00174Completed101/17/2018 10:00:00
32.71165-117.00172Completed201/17/2018 10:00:05
32.71192-117.00171Completed301/17/2018 10:00:10
32.71241-117.0017Completed401/17/2018 10:00:15
32.7135-117.00166Completed501/17/2018 10:00:20
32.71484-117.00162Completed601/17/2018 10:00:25
32.71484-117.00162Completed701/17/2018 10:00:30
32.71484-117.00225Completed801/17/2018 10:00:35
32.71484-117.00265Completed901/17/2018 10:00:40
32.71481-117.00522Completed1001/17/2018 10:00:45
32.71481-117.00565Completed1101/17/2018 10:00:50
32.7148-117.00592Completed1201/17/2018 10:00:55
32.7148-117.0064Completed1301/17/2018 10:01:00
32.7148-117.00743Completed1401/17/2018 10:01:05
32.7148-117.00761Completed1501/17/2018 10:01:10
32.71479-117.00806Completed1601/17/2018 10:01:15
32.7148-117.00896Pending1701/17/2018 10:01:20
32.71479-117.00954Pending1801/17/2018 10:01:25
32.71478-117.01013Pending1901/17/2018 10:01:30
32.71478-117.01066Pending2101/17/2018 10:01:40

Connecting data

    If you are familiar with Power BI with excel, you know what to do. Just create such kind of data for demos in an excel sheet. Connect this excel sheet to Power BI as data source.

    Download Route Map Custom Visual

    Either downloading .pbiviz file from app source or importing visual from the store within Power BI desktop, you can make this visual available for using the same.

    Designing

    Now, you are ready to use this visual to design report.

    Visual parameters

    Just drag and drop above columns in following options respectively,
    • Timestamp: DateTime
    • Latitude: Latitude
    • Longitude: Longitude
    • Segment: Status
    • Color Legend: TrackID
    In Glyphs section, make “End” parameter ON, also choose “Icon” parameter as Custom Image, add “Image URL” as your image URL, and then make “Specify” parameter ON with “Pending” option OFF and “Completed” option ON.

    Now, get ready to see the magic.

    You are done

    In the below image, the circle is a starting point of the route, truck icon specifies the current location of the truck, and after truck icon, the pending route is getting displayed. Pretty readable.
    MAP

    Practical Use

    Delivery Management System

    If you are designing an application for the delivery management system, then you can build this Power BI report using:
      • Read location inputs from IoT Hub using schedule refresh, say after every 15 minutes.
      • Draw this kind of visual in Power BI report
      • Embed Power BI report in your web application 


      Similar Articles