Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mchercol
Helper I
Helper I

Mapa del mundo con paises

Hola necesito implementar un mapa del mundo con paises.

En el cual cargare una tabla con paises exportadores de mercancias.

 

Me podeis ayudar?

 

Gracias por adelantado

 

 

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

Hi @mchercol 

 

To create a world map in Power BI based on data from the countries to which your goods are exported, you can do this by following these steps:

 

1. Import data
First, you'll need to import data with information about the country to which your goods are exported into Power BI. This can be achieved through the "Get Data" feature, which supports multiple data sources, including Excel, CSV files, and more.

Open Power BI Desktop.
Click on "Get Data" and select your data source.
Browse to your data file, select it, and click Load.


2. Use geographic data
Make sure that the country column in your data is correctly recognized as a geographic data type. If not, you can set it manually:

In the Fields pane, locate the column that represents the country.
Click the data type icon next to the column and change it to "Geography".


3. Create a map visual
Next, you can add a map visual to display your data:

In the Visualizations pane, select the Map visual.
Drag the country field to the Location box.
If your data contains egress volume or other quantitative metrics, drag the field to the Size box to display different bubble sizes based on the size of the egress volume.


4. Customize the map
You can customize the appearance of the map by setting options:

Under the Format tab, you can adjust the map's colors, boundaries, labels, and more.
If you're using a Filled map instead of a standard map, you can also adjust the shades of color for different countries based on the volume of exports.


5. Publish and Share
Once you've finished creating and customizing your map, you can save and publish your Power BI report to the Power BI service to share with others.

 

If you have any doubts about how to do this, you can refer to the Retail Analysis Sample PBIX in official PowerBI documentation.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @mchercol 

 

To create a world map in Power BI based on data from the countries to which your goods are exported, you can do this by following these steps:

 

1. Import data
First, you'll need to import data with information about the country to which your goods are exported into Power BI. This can be achieved through the "Get Data" feature, which supports multiple data sources, including Excel, CSV files, and more.

Open Power BI Desktop.
Click on "Get Data" and select your data source.
Browse to your data file, select it, and click Load.


2. Use geographic data
Make sure that the country column in your data is correctly recognized as a geographic data type. If not, you can set it manually:

In the Fields pane, locate the column that represents the country.
Click the data type icon next to the column and change it to "Geography".


3. Create a map visual
Next, you can add a map visual to display your data:

In the Visualizations pane, select the Map visual.
Drag the country field to the Location box.
If your data contains egress volume or other quantitative metrics, drag the field to the Size box to display different bubble sizes based on the size of the egress volume.


4. Customize the map
You can customize the appearance of the map by setting options:

Under the Format tab, you can adjust the map's colors, boundaries, labels, and more.
If you're using a Filled map instead of a standard map, you can also adjust the shades of color for different countries based on the volume of exports.


5. Publish and Share
Once you've finished creating and customizing your map, you can save and publish your Power BI report to the Power BI service to share with others.

 

If you have any doubts about how to do this, you can refer to the Retail Analysis Sample PBIX in official PowerBI documentation.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.