Create Dumbbell Column Chart for Power BI
Step 1 – Get the visual
You can get the visual from our website, Microsoft AppSource or Power BI desktop/web.
a. Website - Go to the visual page and click on ‘Get Trial’ button. You will be redirected to the pricing page where you will provide your email id and click on the ‘Download Visual’ button.
You will receive a mail which will contain the link to download .pbiviz file and a free trial license.
Step 2 – Map your data in the fields available
After importing the visual in Power BI, map data in the given fields. Here we have mapped ‘Age’ in Category, ‘2015 Usage’ in Low , ‘2019 Usage’ in High, ‘2015 Usage Label’ as Low Value Label and '2019 Usage Label' as High Value Label.
In case you want to show labels or tooltip of some other data in the visual, you can map that data under ‘Low Value Label', ‘High Value Label’ or ‘Tooltip’ field respectively.
Step 3 – Format your visual further
a. License Details - If you want to check how your visual works in other Power BI platforms besides Power BI desktop, you have to fill License Details section.
To know more about License Details section, click here.
b. Layout Section – In case you don’t want to see the Conditional Color Formatting, Sorting and Analytics icons present on the top left of the visual. You can switch off the Show Toolbar button.
c. Chart and Legend Section - To know more about these sections, please click the below links
d. X/Y Axis – You can format the X and Y Axis under these sections. You can choose the type of the axis, axis color, axis label formatting and many more.
For more details visit Axis section.
e. Dumbbell Section – Under Dumbbell section, you have all the properties through which you can configure the whole chart like color of the border, transparency, border width and show/hide line, marker properties, label properties, etc.
i. Marker Properties - You can customize marker size, color, fill/not fill color and shape
For example, below we have showcased how to have different shape and fill color in them.
Note - You can modify properties to both your markers individually.
ii. Label Properties – Here you can customize the labels size, color, bold/italic/underline which will be common for all the three labels.
Additionally, you can adjust label position, display unit individually for each labels.
Change marker label have additional property i.e. type by which you can select the type of label which can be Percent, Absolute or Absolute(Percent).
Step 4 – Advance Feature (Conditional Color Formatting and Sorting)
a. Conditional Color Formatting - You can color the dumbbell based on data fields, rules or gradient. You can use Conditional Color Formatting documentation to learn more about this section.
Map the data based on which you want to color them. Click on ‘Conditional Color’ icon on the top left side.
Under Format Style select Rules. Click on Add Rule and you can now change the color of bars based on mapped data.
b. Sorting - PBIVizEdit offers great sorting flexibility for all its visuals. Below, we have shown how to create and apply custom sorting based on the fields you choose.
For more details, visit Sorting section.