Forum Discussion
Importing TopoJSON file to create shape map: what Next?
Ignore the other thread that you mentioned. You are trying to make this way too complicated.
You do not need to know anything about TopoJSON to make this work. Please re-read my previous answer (with the following additions/clarifications).
You need two things to make shape map visualisations:
1: A topoJSON file of the place/area/shape you are going to use. If you are lucky, a nice person on the internet will already have made one that will work for your purposes. It looks to me that you already have this because you have posted a picture of it rendering correctly on GitHub. So you are halfway there (and all you had to do was search the web).
2: Some data that relates to the shape you already have (in 1: above). This is not extracted from the TopoJSON file. It is the data that you want to connect to the shape file. See my previous post's example of "Number of coffee shops in each barrio". Your data will relate to barrios of Barcelona in some way but it will not come from editing the topojson. Remove this idea from your mind.
Get the data in 2: into your powerbi file.
Drag a shapemap on to the report surface.
Add a field to the Location field well.
Use the "+ Add map" in the format section to link the shapefile in 1:
Add another field to the Color Saturation field well.
That's it.
I highly recommend that you follow the instructions here
Thank you for your help!
As I say, I know nothing about topoJSON files etc...
In effect, what I am trying to create is a dataset with the information needed to create a shape map for Barcelona, Spain, which I will then used in different PBI reports. I came across the topoJSON file (of which I posted an extract above) and thought I was in luck.
I actually followed Jimmy Tao's instructions in this thread to set up the data table:
How to import a topoJSON file to make a Shape map
In his example, the field used I see is labeled "coordinates" whereas the file I have found seems to include only "Area" and "Perimiter"; ie no coordinates.
If I use either of these in a Shape map visual, the options under Shape in the format pane are a few countries/regions etc...No sign of Spain, or anywhere within. Does that mean that we are elimited to the maps listed under Shape in the format pane?
Here is a screenshot:
and here is the visual render of the topoJOSON file as seen on github (source for the file)
Ignore the other thread that you mentioned. You are trying to make this way too complicated.
You do not need to know anything about TopoJSON to make this work. Please re-read my previous answer (with the following additions/clarifications).
You need two things to make shape map visualisations:
1: A topoJSON file of the place/area/shape you are going to use. If you are lucky, a nice person on the internet will already have made one that will work for your purposes. It looks to me that you already have this because you have posted a picture of it rendering correctly on GitHub. So you are halfway there (and all you had to do was search the web).
2: Some data that relates to the shape you already have (in 1: above). This is not extracted from the TopoJSON file. It is the data that you want to connect to the shape file. See my previous post's example of "Number of coffee shops in each barrio". Your data will relate to barrios of Barcelona in some way but it will not come from editing the topojson. Remove this idea from your mind.
Get the data in 2: into your powerbi file.
Drag a shapemap on to the report surface.
Add a field to the Location field well.
Use the "+ Add map" in the format section to link the shapefile in 1:
Add another field to the Color Saturation field well.
That's it.
I highly recommend that you follow the instructions here
Success! Thank you for your patience and help!!
I can't believe that it was really that simple! I guess I was wired into thinking I needed to set coordinates (Lat/Long), similar to what I have done in the past with the simple map visual.
As you say, it was as simple as adding data to the visual data bucket from another source, clicking on the "+ Add Map" option under the Shape section in the format pane, navigate to the topoJSON file and voilà! Pretty cool!
Thank you again for your time and assistance!
Great. I'm glad you worked it out.
One thing more - I notice the grey areas on the shape map. This means either :
a) there is no data for those areas (which is fine) or
b) powerbi can't make a link between the shape map and the data (for just the grey areas). There is some sort of hidden magic that powerbi uses to link the shapemap with the data you add. It'll use one of the fields in 'Show map keys'. Sometimes fields don't match up due to spelling or data type mismatches or errors in the shapemap file. You can fix them by editing the data or editing the topojson file. This is something to be aware of.
Thanks again. I did in fact see this when I finally created the shape map. It's just that there are some fields in the location which don't exactly match between both sources. Easily fixed.
Much appreciate it.