Power BI for Developers

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Map

  • 1.  Map

    Gold Contributor
    Posted Nov 22, 2019 07:50 PM
    Good evening everyone,

    I would like to create a map visualization on Power BI using a Map, and add more than a variable on the Map. (Example, want to show customers, suppliers and employees on US map). In other words, want to create multiple layers on the same map.

    Please help.

    Thanks

    ------------------------------
    S B
    Data Manager
    ------------------------------


  • 2.  RE: Map

    Bronze Contributor
    Posted Nov 23, 2019 08:13 AM
    Hi SB,
    if you want to do layering, I advice to use a custom visual called MapBox. You can import and display asa many data and layers as you want. I'm available if you need further info.

    Regards

    ------------------------------
    Andrea Martorana Tusa
    Team Manager Business Intelligence
    Wuerth Phoenix Srl
    Bolzano
    ------------------------------



  • 3.  RE: Map

    Gold Contributor
    Posted Nov 23, 2019 08:50 AM
    Hi Andrea,

    Just to clarify my needs.

    I want to visualize the bubbles on the map representing (Employees, Suppliers, Customers, ...) at the same time on the map. For example, If I am zoom in on New York City, I want to see different colored bubbles for the selected area. Each color will present different people.

    Thank you for help.

    ------------------------------
    S B
    Data Manager
    ------------------------------



  • 4.  RE: Map

    Bronze Contributor
    Posted Nov 23, 2019 09:06 AM
    Hi S B,
    I got your requirements. Then I have a different advice: use the built-in visual called ArcGIS. It is native in Power BI. I'm authoring a series on SQL Shack - articles about database auditing, server performance, data recovery, and more
    SQL Shack - articles about database auditing, server performance, data recovery, and more remove preview
    SQL Shack - articles about database auditing, server performance, data recovery, and more
    Share SQL knowledge, help you learn about SQL and communicate with people from SQL world.
    View this on SQL Shack - articles about database auditing, server performance, data recovery, and more >

    about Power BI and maps. You can refer to the following article where I'm explaining how to create ArcGIS maps in Power BI
    https://www.sqlshack.com/create-geographic-maps-power-bi-using-arcgis/

    Hope it can help. Feel free to contact me for any further detail

    Regards

    ------------------------------
    Andrea Martorana Tusa
    Team Manager Business Intelligence
    Wuerth Phoenix Srl
    Bolzano
    ------------------------------



  • 5.  RE: Map

    Bronze Contributor
    Posted 6 days ago
    As far as i know , driving layers data in powerBI maps is not possible.. Even with Mapbox or Arcgis . you have to choose a "data"layer interactive with PowerBi data , and "Static" layers in a backside (Mapbox or ArcGis)   .. Microsoft is about to announce some news about maps visual in powerBi , with Azure Maps  see thats post here: https://myignite.techcommunity.microsoft.com/sessions/84343?source=sessions  and the video at minute 16 , where Richard Brunditt show you a live layer from a geoJson file.. very impressive !  but Azure Maps is not Free at all..  On another side , we have to wait about a "EasyTerritory" visual for PowerBI : https://www.easyterritory.com/products/territory-management-route-optimization-excel-power-bi/

    not free at all !

    ------------------------------
    Antoine Dirat
    0101321896
    ------------------------------



  • 6.  RE: Map

    Bronze Contributor
    Posted 5 days ago
    ​What I would do, if the different types of data (customers,suppliers,employees,etc...) have similar data that you can use as a connection point, create a new table, use the union function to union the different tables you have for customers,suppliers,etc..., now you have all of your data types on one table, and can put them all on the map, and if you're using ArcGIS maps, us the customers/suppliers column as your "Color"

    Type = Union(Table,Table,Table)

    Like that

    ------------------------------
    ryan heitzman
    ------------------------------