Map Visualisation Type in Cohort Analysis Showcase

Power BI Data Model
1

Hi,

I’m asking for USA Map in Cohort analysis showcase, I tried to find which map visual you use in displaying (USA MAP) e.g.: Map, Filled Map,Esri,…etc , I want to do the same with another country (lat , lon) Particularly (Saudi Arabia) My Question is :slight_smile:

  1. Which map visual tool you use?
    2)On this tool, I didn’t find (lat & lon) on it how the Map moves and go to a location without lat & lon?

cohort
cohort.JPG847×477 97.5 KB
Lat%20and%20lon
Lat and lon.JPG810×416 28.3 KB
MAp%20USA

1 Like
2

Hi,

The map visual used is a Shapemap, as you can tell when clicking the visual. Shapemap requires a vector based map, (so lat and lon are not required) a few have been added as defaults and you can add more files. Under Format, Shape you can select an available map or add a map. Search on google to obtain the *.shp file for your country of choice. There are several websites that provide a free conversion tool, you need to convert a *.shp file and *.dbf file to a geojson or topojson extension. It is a bit technical I am afraid. The map uses keys=your geographic datafield to connect your data with a similar key to the shape (key being a state or a province or postcode area) in the map.

Paul

Enterprise%20DNA%20Expert%20-%20Small

1 Like
3

I didn’t understood your answer could you explain it more step-wise ?

4

ok, it is rather complicated indeed,
You need a shape map, in Power BI a *.(topo)json file. I have created one for you, see attached.

Merge your own data with the mapkeys and you are done.SA.pbix (509.7 KB)

Paul

Enterprise%20DNA%20Expert%20-%20Small

1 Like
5

This is the json file from the zip file, you can use this in your model.
The map keys show under Format, Shape map keys.
dbfprjshp.json (1.4 MB)

Paul

Enterprise%20DNA%20Expert%20-%20Small

1 Like
6

@Paul

Thanks for outlining those steps, learned something new today :slight_smile:

Nick

Enterprise%20DNA%20Expert%20-%20Small

7

Thank you so much , you means I upload a file with longitude , latitude into the mentioned page?

8

Can You Help me please , Here is (csv) file with Lat & long (https://drive.google.com/open?id=1YcsBYM98eUxor2GWa0-nqvIMgwcALoS0) , can you show me as an example how we can manipulate them on PBix file? For (0) lat & long it means (Un-Known location).

1 Like
9

How can we get shape visual inside power bi report?

1 Like
10

Hi,
Please read carefully through the explanation, the map you referred to is a shape map, not a lat/lon map which show points on the map.
So you cannot use latitude and longitude for a shape map but instead you have to “create” the boundaries of the shapes like states or provinces. The 3 files I refer to hold the information to convert into a json file that can be read by the Power BI visual.

The shape map visual is already present in Power BI.
Paul

Enterprise%20DNA%20Expert%20-%20Small

11

Thank You for your replay I understand now , But can you show me how to upload it (JOSON Boundaries) into PBIx file ?
I mean I cannot find a custom visual that I can get the Joson file and convert it into map boundaries (Check My Images Below)?
I understand how to export it into Map boundaries file, Assuming that you didn’t send me the PBix file

I’m appreciated if you can show me how is that (Upload the Map Boundaries Into Power bi report) this is the missing point I didn’t know how to do it?

Map%20Visual
Map Visual.JPG866×441 29.5 KB

Map
Map.JPG853×519 31 KB

12

Hi,
ok. I am not behind my pc, but I recall you may have to manually activate this visual on first time use. Please check under options whether you have the shape map visual selected, once you have it should show.
Then follow the steps, hope this works for you now.

Paul

Enterprise%20DNA%20Expert%20-%20Small

1 Like
13

Ok Thank you so much Paul , I got it now.