Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

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

  • 8 February 2017
  • Author: DevinKnight
  • Number of views: 295
  • 0 Comments

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.


Print
Categories: Uncategorized
Tags:
Rate this article:
No rating
DevinKnight

DevinKnightDevinKnight

Other posts by DevinKnight

Please login or register to post comments.