Org Chart

Hierarchies that carry their performance with them

Visualise organisational structures, reporting lines and process flows as an interactive tree, with KPI status on every node so you can see where the org is off target.

Certified by Microsoft

Org Chart

Illustration of the visual's layout.

An org chart, or organogram, is a tree of who reports to whom. The Org Chart for Power BI builds that tree from a parent-child table: an Entity ID and a Parent ID per row, which is the shape HR systems, ERP cost-centre hierarchies and legal-entity registers already export. The same two fields draw a reporting structure, a subsidiary ownership chart or an approval flow.

Each node can also carry a KPI. Bind a value, a target and a period and the node shows a status colour, so a headcount tree doubles as a performance dashboard and a manager scanning it finds the under-target team before opening another report page. Photos, accent colours and swimlanes come from further fields in the same table.

Capabilities

  • KPI performance indicators

    Each node shows a status derived from variance against target, so weak spots surface without reading a single number.

  • Swimlanes

    Group nodes into horizontal or vertical lanes by department, region or any other category.

  • Dual orientation

    Switch between left-to-right and top-down layouts to suit the shape of the hierarchy.

  • Expand and collapse

    Collapse branches individually or toggle the whole tree, with zoom, fit-to-screen and smooth panning for large charts.

  • Interactive legend

    Click a KPI status in the legend to filter the tree down to just the nodes in that state.

  • Photos and accent colours

    Bind base-64 images for people or units, and set a per-node accent colour from your data.

Where it's used

  • Organisational structure and headcount reporting
  • Performance management cascades
  • Process and approval flow documentation
  • Group structures and subsidiary ownership

Try it with sample data

A ready-made Power BI report with the visual set up, so you can see it working before binding your own data.

Download sample

Pricing & LicensingDepending on your needs

AppSource · Pay per user

Power BI Online

$259.90 per year

10 users at $25.99 per user, per year. Billed by Microsoft.

Direct license · Unlimited users (1 site)

Power BI Embedded and Report Server

 per year

 

What's the difference between AppSource and direct licensing?

AppSource licensing compared with direct licensing
AppSource licenseDirect license
Best forPower BI Service and DesktopReports at app.powerbi.com and in the mobile appsAll other environmentsReport Server, Embedded, Publish to web, the SharePoint Power BI web part, sovereign clouds, offline
PricingPer userPriced on each Marketplace listingPer visual or all-visuals bundleAnnual or 3-year term
BillingMicrosoftOn your existing Microsoft accountChartPadVia our payment partner Paddle
RenewalAutomaticManaged in the Microsoft 365 admin centerManual, every 1 or 3 yearsA report editor updates the visual with the fresh key
Who needs oneEvery editor and viewerAssigned by an admin in the Microsoft 365 admin centerNo per-user licensesOne key covers every editor and viewer for the licensed company; an editor pastes it into the visual's Format pane

Explore other visuals