Help - Creation of map municipalities Colombia

[Syndicate_Admin]

Good day everyone!

I'm starting in Power Bi and I saw this video about the municipalities of Colombia, I have tried to recreate it in various ways but I have not been able to. For my work this option would be very useful since I currently use Excel but it has limitations with certain municipalities in Colombia.

If someone could help me with the database or how I can configure it to look like it is in the video, it would help me a lot.

Link video: https://www.youtube.com/watch?v=lCYQ5QjSIRY&ab_channel=argemiroperezcaballero

[Syndicate_Admin]

The process for creating the map (of shapes) is as follows:

1. You search for the Municipalities of Colombia file (it can be in .shp .geojson format or whatever you find). On the DANE website (on the geoportal) you can find them.

2. Then you go to a free tool like mapshaper.org and convert it to TOPOjson format (the only format that the shape map object accepts).

3. Open the shape map object and set it to custom map

In the file browser, you're going to select the TOPOjson map that you made into a mapshaper

3. Finally, you must look for a table that contains the DIVIPOLA by municipalities and the loads and power BI (this is done so that the DIVIPOLA field does martch with the implicit field it has). This DIVIPOLA puts it in location

At the end you should have a map like this:

This is the GDP:

Map of Municipalities Colombia.pbix

[Cristian991229]

Hola a todos, comparto la forma en que logré usar el archivo Json y como instalarlo

Debemos descargar el archivo de la página https://raw.githubusercontent.com/finiterank/mapa-colombia-js/master/colombia-municipios.json (que nos compartió anteriormente el usuario Bifinity_75)

Ahí se abre una página, yo le di en "guardar como"

Guarden el archivo donde quieran

Ahora necesitan tener habilitado el gráfico especial de "Mapa de áreas" el cual, creo que es experimental o de beta, y toca habilitarlo manualmente. Para eso se van a "Archivo", luego, "Opciones y configuración", luego "Opciones"

Luego van a "Características de versión preliminar" y activan la casilla "Objeto visual Mapa de formas".

Reinician PowerBi y tienen el nuevo gráfico, lo seleccionan, aparece primero EEUU, en configuración del gráfico lo cambian por "personalizado" y ahí cargan el archivo Json

Muchas gracias a todos

Que #JulioZorra los bendiga

[Syndicate_Admin]

I could not load the JSON data well, how does the data table organize for the map to load?

[Syndicate_Admin]

Hello, I tried to connect the JSON data and I do not know how to fit well, how do I organize the data on the pop-up screen for the map to load?

[Syndicate_Admin]

Hello, excellent! Thank you very much for the explanation.

A question, to make a map of Colombia with the municipalities of San Andrés and Providencia included, but in large size, where can I find the .json?

 

[Bifinity_75 · Accepted solution]

Hola @Syndicate_Admin, lo primero que tienes que hacer es descargarte éste fichero Json de la topologia de municipios de Colombia:
https://raw.githubusercontent.com/finiterank/mapa-colombia-js/master/colombia-municipios.json

Despúes de descargarlo, sólo tienes que insertar un mapa de formas:

acto seguido, en la configuración del mapa, selecciona "Mapa personalizado", y carga el fichero JSON:

Y ya tienes cargado el mapa por municipios.

El resultado:

Después si quieres detallar valores para cada municipio, utiliza el listado de municipios que trae el Json.

Un saludo

[Syndicate_Admin]

After downloading the Json, how do I integrate with PowerBi? Do I charge them as data? Do I paste it into a root folder?

[Syndicate_Admin]

Good day, I also had this same doubt and found this post. I'm just starting in power bi, I was able to download the json and load the information and the map was generated

But let's say relate the data I need, let's say population or X value I have not been able to add them and generate the filter you have in the photo I could not generate.

I think it's a very basic question. 🙈