SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)

Power BI Module 03

In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual.  The Hexbin Scatterplot is a variation of the traditional Scatter Chart but instead of using bubble size it relies on color saturation and hexbins to show value distribution.  You should consider using this chart when you’re more interested in visualizing density instead of individuals points themselves.

Module 03 – Hexbin Scatterplot

Downloads

Key Takeaways

  • The Hexbin Scatterplot relies on color saturation to portray data rather than bubble size.
  • The darker the hexbin, the larger the value distribution.

image

The darker colored hexbins represent larger data values than the lighter colored bins.

  • Under the Format paintbrush you can optionally increase/decrease the size radius of the hexbins.
  • You can also change what is displayed in the chart by turning off the Dots, Hexbins, or the Rug representation

image

The Hexbin Scatterplot has several format changes that can be customized.

  • Dots – These are a single points representing the categorical data placed in the Details field property.

image

  • Hexbins – Hexbins are great when you’re looking shows density instead of individuals values. The color saturation is determined by frequency of values or the field placed in the Value field property.

image

  • Rug – Rug plots refer to the indicators in the margin that show on both vertical and horizontal axis where data points lie.

image

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 20+ courses.


Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Comments

Leave a comment on the original post [devinknightsql.com, opens in a new window]

Loading comments...