---
title: Power BI Custom Visuals - Drilldown Cartogram
description: The Drilldown Cartogram Power BI Custom Visual displays a circle for each location with varying size and color based on specific values you provide.
---

[Pragmatic Works Nerd News ](https://pragmaticworks.com/blog)

# [Power BI Custom Visuals - Drilldown Cartogram](https://pragmaticworks.com/blog/power-bi-custom-visuals-drilldown-cartogram)

 Written by [Devin Knight](https://pragmaticworks.com/blog/author/devin-knight) | Jul 13, 2017

In this module, you will learn how to use the Drilldown Cartogram Custom Visual.  The Drilldown Cartogram is a map visual that displays a circle for each location with varying size and color based on specific values you provide.

### Module 59 – Drilldown Cartogram

### Downloads

- Power BI Custom Visual – [Drilldown Cartogram](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Ejn3BZIKy-NHk0DHsQUqT5QBx8WaO5HCyu0Qo7pWOzaWmw?e=cHNAGd)
- Dataset – [Military Veterans.xlsx](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Em3EhAcS3BxDp41MBmgdJMwBEDZ_BDaPlejX8prRGk83iA?e=MSmyld)
- Completed Example – [Module 59 – Drilldown Cartogram.pbix](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Em3EhAcS3BxDp41MBmgdJMwBEDZ_BDaPlejX8prRGk83iA?e=MSmyld)
- Shape Level 1 – [https://uat.gramener.com/static/c3/US_adm1.json](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Em3EhAcS3BxDp41MBmgdJMwBEDZ_BDaPlejX8prRGk83iA?e=MSmyld)
- Shape Level 2 – [https://uat.gramener.com/static/c3/US_adm2.json](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Em3EhAcS3BxDp41MBmgdJMwBEDZ_BDaPlejX8prRGk83iA?e=MSmyld)

### Key Takeaways

- Displays a circle for each location with the size and color based on the values you specify.
- Allows you to drill down through your hierarchy data.
- You must add a shape file yourself to use this visual.

<https://devinknightsql.files.wordpress.com/2017/07/image5.png>

*This Drilldown Cartogram map shows military veterans by county in the United States.*

- Under the **Format** paintbrush, there are several sections available to modify the appearance.
- Under the **Data colors **section, you can adjust the type of colors used on the map and the thresholds that determine their color.

<https://devinknightsql.files.wordpress.com/2017/07/image6.png>

- The **Shape** properties should really be your first stop when working with this visual. Without configuring at least the Level 1 property with a shape file, you will see nothing on your map. You can also change the type of map projection is used here.

<https://devinknightsql.files.wordpress.com/2017/07/image7.png>

- Under the **Default color** section, you can control things like the color of the border between shapes and how thick the lines are.

<https://devinknightsql.files.wordpress.com/2017/07/image8.png>

- The **Circle settings** allow you to control the size of the circles of the map and the border thickness around each circle as well.

<https://devinknightsql.files.wordpress.com/2017/07/image9.png>

- Using the **Zoom** properties you can change the behavior of the visual when you zoom into a selection you’ve made or manually zooming on your own.

<https://devinknightsql.files.wordpress.com/2017/07/image10.png>

- Turning on/off the **Collision** property will control the “bounce” you may notice when the circles touch each other on the map.

<https://devinknightsql.files.wordpress.com/2017/07/image11.png>

In addition to these properties, there are settings that appear on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

### Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On-Demand Training platform or [view my previous blog posts](https://blog.pragmaticworks.com/topic/power-bi-custom-visuals).

[View full post](https://pragmaticworks.com/blog/power-bi-custom-visuals-drilldown-cartogram)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Devin Knight"
  },
  "dateModified" : "2023-03-28T17:11:09.653Z",
  "datePublished" : "2017-07-13T12:00:00Z",
  "headline" : "Power BI Custom Visuals - Drilldown Cartogram",
  "image" : {
    "@type" : "ImageObject",
    "height" : 200,
    "url" : "http://blog.pragmaticworks.com/hubfs/Banners/Power-BI-Banner.jpg",
    "width" : 600
  },
  "mainEntityOfPage" : "https://pragmaticworks.com/blog/power-bi-custom-visuals-drilldown-cartogram",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://blog.pragmaticworks.com/hubfs/PW%20Logo-2.png",
      "width" : 217.56097
    },
    "name" : "Pragmatic Works Blog"
  }
}
```