Introduction: Dumbbell Column Chart

You are here:

Unleash the power of comparison with the Dumbbell Column Chart

Data visualisations play a fundamental role in answering an important data question:”How does result A compare to result B?”. Typical examples of these questions are:

  • How does the sales of this month compare to the sales of last month?
  • What is the difference between the number of documents processed this year compared to 2017?
  • How does the number of planned-visitors compare to the number of unplanned-visitors at our locations?

Key in answering these kind of questions is explicitly visualizing the difference between the two results. This is the strength of the Dumbbell Column Chart: showing the values and the difference between them.

Key features of the Dumbbell Column Chart are:
Format objects: each of the data point objects (shape and line) can be formatted by selecting a color and size. Additionally, the line can be switched on/off and for the shape one can switch on/off the fill color;
Axis formatting options: in line with the options you know from the Power BI Clustered column & bar charts, so no need to learn a new interface; theme colors and settings are supported;
Selection & Highlighting: like in standard Power BI charts you can make use of the Selection & Highlighting functions within the Dumbbell Column Chart;
Context menu: like in standard Power BI charts you have access to the context menu to Include/Exclude data points;
Full Tooltip support: besides the default Tooltip behavior (show the value of the element you hover) you can also add additional feeds to the tooltip;
Full Bookmark support: like any of the standard visuals the Dumbbell Column Chart supports Bookmarks.

How to use: Build visual

In the Build visual pane, of three fields available you need to specify at least the first two fields, being: Axis and Values. The field Tooltips is optional. 

  • Axis: here you add the field(s) containing the categories you want to place on the x-axis. If you place multiple fields here you can drill through the different fields as if they were levels of a hierarchy. You can also use any hierarchy you already have in your data set.
  • Values: this is where you specify the measures as they will be displayed on the y-axis. The value of each measure will determine the location of the markers on the y-axis scale. By default it will SUM all the values per category, but you can also select any of the other aggregation functions (like Average, Minimum, Maximum, Count, etc.).
  • Tooltips: the fields added here will shown in the tooltip when the user hovers a specific data point.

How to use: Format visual

Besides the standard Format options there are a number of additional formatting properties that allow you to change the default behavior of the visual:

  • License: here you can enter your license information to disable any license reminders.
  • Legend: here you can toggle the Title option on and add a Legend Name Title, or change the Color and Text Size.
  • X-Axis: the formatting options for the x-axis (category axis) are similar to the options available within the Clustered column chart (standard Power BI visual). These familiar options allow you to change the visibility and formatting of the x-axis elements (like: Color, Text size, Font family, Title, Gridlines, etc.).
  • Y-Axis: the formatting options for the y-axis (value axis) are similar to the options available within the Clustered column chart (standard Power BI visual). These familiar options allow you to change the visibility and formatting of the y-axis elements (like: Start and End values, Color, Text size, Font family, Display Units, Decimal Places, Gridlines, etc.).
  • Data point: here you influence the properties of the shapes and connecting line. You can switch on/off the Fill of the shapes. Select different shapes from the Primary/ Secondary Shape drop-down menu, increase/ decrease the Stroke width and the Size will determine the size of the shapes themselves. You can also switch on/off the connecting line with the Lines setting and change the width and color of the line with Line width and Line color.
  • Data colors: within this section you can change the color of the shape for each value or add conditional formatting.
  • Data labels: within this section you can enable and change the format of the data labels. You can adjust the color of both measures, change the display units and decimal places. Enable overflow text, set the text size and font. The background can be switched off/on per value and you can set a background color and opacity.

How to use: Analytics

You can highlight many interesting trends and insights by creating dynamic reference lines in the Analytics pane. To see the analytic lines, select the visual and click the Analytics icon (magnifying glass).

Available Analytics lines:

  • Constant line: displays the value specified, helps to track metrics and desired goals
  • Min line: displays the lowest value points on the axis
  • Max line: displays the highest value points on the axis
  • Average line: displays the data average
  • Median line: displays the middle value
  • Percentile line: displays the value (or score) below which x% of the observations may be found

Format your line by specifying the ColorTransparency percentage, Line width, style and position. For most lines you can specify the visual Measure to base your line upon, by selecting Primary or Secondary value from the drop-down menu.

If you want to have a data label, switch Data label On. You get additional formatting options for your data label, such as: Color, Text, Horizontal and Vertical position, Display units and Value decimal places.

For any questions or remarks about this Visual, please contact us by email at Nova Silva Support.

Next Tutorial: how to use the Dumbbell Column Chart
Table of Contents