Lipstick Column (Pro)


Microsoft PBI Certified
(2 ratings)
Download SampleInstructions

Overlapping columns to compare two numerical variables per category to clearly show surplus/shortage

The conceptual idea with Lipstick Column (Pro) is to compare a measure against a reference by overlapping the measure onto the reference measure resulting in visual storytelling with greater expositional power. This kind of chart shows surpluses and shortages with remarkable precision, particularly when appropriate grids are added to it.
They are frequently used to show level of progress to an objective/goal or against a benchmark. Common use cases-
Finance: Budget vs Actual, Revenue/Expense current vs prior year
Sales and Marketing: Actual vs Forecast, Sales Current Year vs Prior Year
Others: individual v. aggregate scores, surveyed v. the entire population

Using PBIVizEdit's Lipstick Column (Pro) visual you can create, variations of overlay columns. For example,
  • Thermometer column chart
  • Column overlap chart
  • Column chart with patterns
This visual is free forever in Power BI Desktop.
Trial License:
Power BI web service, click on Buy now to get free trial license. For Other Power BI platforms, to get free trial license click here

Purchase License:
Power BI service (Power BI Pro) - Purchase license available in the Plans + Pricing tab. Power BI premium (A1 to A6 and P1 to P5 SKUs) - Purchase license from our website

  • Conditional Color formatting
  • Custom sorting
  • Modify column offset, width, color and transparency
  • Formatting with patterns
  • Custom label formatting
  • General Power BI features like tooltip page, drill down

PBIVizEdit is a powerful online tool to easily create Power BI custom visuals with simple mouse clicks in 15 mins. It also provides packages for ready-to-use custom visuals. To try our tool or to upgrade your single custom visual purchase to a package, visit our website at

Visual capabilities

This visual is certified by Power BI

At a glance