Power BI Custom Visuals Class (Module 37 – Gap Analysis)

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

Key Takeaways

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

image

This Gap Analysis visual compares this year vs last years 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.

image

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

image

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

image

  • 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.

image

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

image

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

image

  • 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.

image

  • 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.

image

In addition to these properties you have a set of settings that appears 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.  Click here to learn more about this training platform that includes 25+ courses.

Catch up on all the Power BI Custom Visuals blog posts here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s