Lipstick Column (Pro)


(2 hodnotenia)
Stiahnuť ukážkuPokyny

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. To use it in: Power BI service (Power BI Pro) - Purchase license avaiable in the "Plans + Pricing" tab. Power BI premium (A1 to A6 and P1 to P5 SKUs) - Purchase license from our website

  • Modify column offset, width, colour 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

Možnosti vizuálu

Tento vizuál je certifikovaný službou Power BI

Súhrnný prehľad