Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image1_icon300.png

Org Chart by SmartVisuals

by SmartVisuals.io

Free Trial
Download SampleInstructions

Org chart from an employee and manager table. No DAX, no root errors, no blocked viewers.

The organization chart Power BI reports have been missing. Bind Employee ID, Manager ID and Name and the visual builds the whole hierarchy itself - no DAX path functions, no parent-child columns, no hard-coded levels. Missing managers, several top people, reporting loops and duplicate ids are handled and explained in a data-notes strip, never shown as an error.

Free features (no caps, no watermark):

  • Unlimited people from any id type (numbers, codes, e-mails); tested with 50,000 people
  • Branch view from a click or a slicer with a breadcrumb back, expand and collapse that the report remembers, expand all, expand to level N
  • Neighbourhood view: a person's managers, peers and direct reports on one screen
  • Search across the whole organization that ignores accents and case, with the path to the person highlighted
  • Photos (data URI columns) or initials, job title, department, extra lines, direct-report count, badges from flag columns
  • Positions and vacancies: job shares, one person on two positions, assistants beside their manager, contractors
  • Dotted-line managers, team cards for large flat teams, swimlanes by department, top-down or left-to-right layouts
  • Card actions: open the HR profile, chat in Teams, write an e-mail (https links only, on a click)
  • Vector PDF export (one page or poster tiles A4 / A3 / A1) and a CSV data-quality report
  • Privacy threshold that hides figures for small groups
  • Four themes with their own card style, every colour, font and shape adjustable; color cards by department, level or a value (two-colour scale), with native conditional formatting (fx) on card fill and per-row rules
  • Format on the canvas (on-object formatting): click a card, a connector, the legend, the toolbar or a strip and change it right there
  • Your model's format strings, including dynamic format strings, on card figures and tooltips
  • Cross-filtering (a click selects the person or the whole team, your choice), drill-through, report page tooltips, bookmarks that open the branches of the people they select, keyboard navigation, screen-reader list view, high contrast; 20 languages

Premium features (per-user license through Microsoft Marketplace):

  • Headcount, FTE and cost roll-ups: how many people and how much budget sit under every manager, for any measure
  • Span of control: bands, coloring, managers of one and over-span lists
  • Insights strip and organization health panel: layers, manager ratio, vacancy rate, cost per head
  • Plan vs actual: target headcount or budget against actual, with variance on every card
  • Snapshot comparison and history: joiners, leavers, moves and new titles between any two dates, attrition per branch, a timeline player
  • Scenario planning: move teams by drag and drop, add and vacate positions, compare the scenario with today and export the moves as CSV
  • Org-unit view, team composition bars and the people list export

A new visual starts with free features only: switch on Roll-Ups on Cards and the Insights Strip under Roll-Ups & Span of Control. Reports created before version 1.1.0.0 keep them exactly as they were. Every premium feature is fully unlocked while editing, so you can evaluate everything before buying. Viewers without a license always see the full free chart, never a blocked or watermarked visual. No data leaves Power BI: the visual makes no external calls, and HR data stays in your report.

Ready-made Power Query recipes for Microsoft Entra ID, Excel and common HR systems are on smartvisuals.io.

Support: https://smartvisuals.io/support - hello@smartvisuals.io

Visual capabilities

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

At a glance

https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image2_01overview.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image3_02branchspanhealth.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image4_03snapshotcomparison.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image5_04searchdetailed.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-org-chart-2825e580-46b1-4309-94f5-571ef58f9e0f/image0_05scenarioplanning.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies