Regularly the standard Clustered Column chart is used to compare two measures within a number of categories. If one of these measures has been added as a reference (secondary measure) to increase the context of the primary measure it would be better to clearly show this priority difference.

This is precisely what the Lipstick Column Chart does: It shows the primary measure per category on the foreground, and places the secondary measure behind it for a precise comparison of both values. Since both values are placed on top of each other it also becomes a more compact alternative to show both measures per category.

Key features of the Lipstick Column Chart are:

Format the objects: Each of the bars (both primary and secondary) can be formatted like the bars in the Power BI Clustered Bar/Column Chart;

The Axis formatting options are in line with the options you know from the Power BI Clustered Column & Bar Charts, so no need to learn a new interface;

Selection & Highlighting: Like in standard Power BI Charts you can make use of the Selection & Highlighting functions within the Lipstick 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 behaviour (show the value of the element you hover) you can also add additional fields to the tooltip. You can even use another report page as a tooltip.

Full Bookmark support: like any of the standard visuals the Lipstick Column Chart supports Bookmarks

Conditional formatting: The Lipstick Column Chart supports conditional formatting for both bars.

Data labels: Like any standard visual you also can show data labels in the Lipstick Column Chart

Analytics lines Reference lines can be added to the Lipstick Column Chart by configuring them in the Analytics pane;

All functionality of the Lipstick Column Chart is available for free to try within Power BI Desktop. A licensed version is available for production usage and sharing the reports with your colleagues in Power BI Service. A license can be purchased on our website. Need more information? Visit our site at: https://visuals.novasilva.com

Lipstick Column Chart

by Nova Silva