https://store-images.s-microsoft.com/image/apps.32627.f6b7787e-a5ed-498b-bf52-74c387f4ade6.02e5be4b-61d7-4bba-9926-1d42e0e3538b.e6c2705e-12f8-4503-b43e-f9bdf0e00352

Overlapping Column (Standard)

by PBIVizEdit.com

(2 ratings)
Download SampleInstructions

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



This visual is not certified by Microsoft Power BI team. If you want the certified version of this visual, please check Overlapping Column Chart (Pro). Please note all our Pro visuals can be exported to PPT/PDF.
All of our visuals, including those not certified by Microsoft, do not access any external services or resources and this can be verified with browser (Edge, Chrome, Firefox) developer tools.

Description

The conceptual idea with Overlapping Column 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 If you

Using PBIVizEdit's Overlapping Column visual you can create variations of overlay columns. For example,
  • Thermometer column chart
  • Lipstick column chart
  • Column chart with patterns
Features available with PBIVizEdit's Overlapping Column
  • Small multiple/Trellis
  • Analytics Panel - Reference line and bands, Error bar and bands
  • Custom label formatting
  • Modify Columns width, color and transparency
  • Formatting with patterns
  • Custom sorting
  • Conditional color formatting
  • General Power BI features like tooltip page, drill down

License Details

Power BI Platforms Get trial/Buy
Desktop, Web, Mobile,
Embed in Microsoft SharePoint
Embed in Internal applications (needs per-user license)
Click on Buy now button on our website
Report Server
Public Website
Embed in External applications
Visit our website www.pbivizedit.com/pricing


Get the complete suite of visuals at price of 3 - This visual is a part of our standard suite. If you want to purchase our complete standard suite, please visit our website.


Need to modify this visual further? - With our GUI click-and-select editor, you can further customize this visual at our website in 15 mins. Or engage us to create a trial visual for free.


ABOUT US

PBIVizEdit visuals are used by 10,000+ companies globally. In addition to 40+ ready-to-use Power BI custom visuals, we also have a powerful GUI click-and-select editor to modify or create new custom visuals. Or you can engage PBIVizEdit's experts to create desired Power BI visuals. To know more, visit our website at www.pbivizedit.com

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://store-images.s-microsoft.com/image/apps.16648.f6b7787e-a5ed-498b-bf52-74c387f4ade6.02e5be4b-61d7-4bba-9926-1d42e0e3538b.ac93bdcb-cd50-4d1a-8149-3e4d74061914
https://store-images.s-microsoft.com/image/apps.142.f6b7787e-a5ed-498b-bf52-74c387f4ade6.02e5be4b-61d7-4bba-9926-1d42e0e3538b.e1fe2c07-855c-4d58-96e9-bcfcc1335466
https://store-images.s-microsoft.com/image/apps.21848.f6b7787e-a5ed-498b-bf52-74c387f4ade6.02e5be4b-61d7-4bba-9926-1d42e0e3538b.24256516-2ac6-42c2-87a2-3649104da36f
https://store-images.s-microsoft.com/image/apps.31051.f6b7787e-a5ed-498b-bf52-74c387f4ade6.02e5be4b-61d7-4bba-9926-1d42e0e3538b.4889e10f-baf1-49ee-b896-6e0bf76ab9b8
https://store-images.s-microsoft.com/image/apps.47637.f6b7787e-a5ed-498b-bf52-74c387f4ade6.bebf444f-3394-4a06-9135-2f408ade7326.4f2e0e5c-45e6-4296-ba28-72d9ecb727db