Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A data analyst is creating a Power BI report for a global e-commerce company. The report needs to display sales performance across different countries. The company requires a visual that clearly shows the sales amount for each country, with larger sales represented by larger, distinct areas on a map. Which Power BI visual type is most suitable for this requirement?
- AArcGIS Map for Power BI
- BAzure Map
- CShape Map
- DFilled Map
Show answer & explanationAnswer & explanation
Correct answer: D. Filled Map
A Filled Map visual in Power BI shades geographic areas (like countries, states, or regions) based on the value of a measure. This directly addresses the requirement of showing sales amounts with larger sales represented by larger, distinct *areas* (shading) on a map, making it easy to visually compare performance across different regions.
Why the other options are wrong
- A. ArcGIS Map for Power BI offers advanced geospatial analysis and visualization, including heatmaps and custom layers, but for a straightforward 'larger sales = larger distinct areas' (shading of countries), the native Filled Map is sufficient and more direct.
- B. Azure Map is a more advanced visual that offers various map styles and layers, including heatmaps and bubble layers, but a simple Filled Map is more direct for shading entire country areas based on a single measure.
- C. A Shape Map uses custom shapes (often polygons) to represent regions and can be shaded, but it requires specific GeoJSON files for custom regional boundaries, which isn't explicitly mentioned as available or needed for standard countries. Filled Map is simpler for standard country data.
Power BI Filled Map
A choropleth map visual in Power BI that shades predefined geographic regions (like countries, states, or postal codes) based on the value of a measure, allowing for quick visual comparison of data across regions.
- Uses standard geographic hierarchies.
- Shades entire regions based on a measure.
- Ideal for showing distribution or intensity across areas.
Memory trick: Map your sales, fill the countries, see the patterns, no more boundaries.