---
title: Power BI Custom Visuals - Gap Analysis
description: The Gap Analysis Power BI Custom Visual is used to analyze the difference between two different groups of data you have.
---

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

# [Power BI Custom Visuals - Gap Analysis](https://pragmaticworks.com/blog/power-bi-custom-visuals-gap-analysis)

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

In this module, you will learn how to use the Gap Analysis Power BI Custom Visual.  The Gap Analysis visual is used to analyze the difference between two different groups of data you have.  For example, you might use it to analyze the gap between two answers people gave in survey response data.

### Module 37 – Gap Analysis

### Downloads

- Power BI Custom Visual – [Gap Analysis](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Ejn3BZIKy-NHk0DHsQUqT5QBx8WaO5HCyu0Qo7pWOzaWmw?e=DwFao7)
- Dataset – [Country Sales.xlsx](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/EqtTAFOKTaBOstRm6HAv_AUBf4wRUbNlTWvJmAf3dm6RsQ?e=xpPniI)
- Completed Example – [Module 37 – Gap Analysis.pbix](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/EqtTAFOKTaBOstRm6HAv_AUBf4wRUbNlTWvJmAf3dm6RsQ?e=xpPniI)

### Key Takeaways

- Use this visual for analyzing the gap between groups of your data.

<https://devinknightsql.files.wordpress.com/2017/02/image2.png>

*This Gap Analysis visual compares this year vs last year's retail sales.*

- Under the **Format** paintbrush, there are several customizations available for the Gap Analysis.
- Under the **Statement **section, you can increase/decrease and change the color of the categorical data (Clothing, Jewelry, Electronics) text you’re analyzing. In my example, I increased the font to 16 and made the text black.

<https://devinknightsql.files.wordpress.com/2017/02/image3.png>

- The **Statement Sort** section allows you to adjust the sort order of the categorical data.

<https://devinknightsql.files.wordpress.com/2017/02/image4.png>

- Under **Group Circle,** you can change the colors of the circles that are on the beginning and the end of the Gap Bar.

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

- The **Group Circle Data Label** section allows you to turn on/off the labels and adjust the color of the labels that appear next to the circles.

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

- Using the **Group Legend** properties, you can increase the size of the font in your legend and increase the size of the legend circles.

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

- You can also change the font size of the details section in the top left of the visual by adjusting the **Details on hover** properties.

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

- Under the **Gap Bar **section, you can change the color and size of the gap bars. You can even make the colors all different based on the values you have in the statement field.

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

- The **Gap Label **section allows you to adjust the labels on the gap bar. You can change the position, color and size of the labels here.

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

In addition to these properties, you have 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-gap-analysis)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Devin Knight"
  },
  "dateModified" : "2023-03-28T17:26:04.082Z",
  "datePublished" : "2017-02-09T14:17:56Z",
  "headline" : "Power BI Custom Visuals - Gap Analysis",
  "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-gap-analysis",
  "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"
  }
}
```