Tree · Hierarchy

The whole organisation on one page, and the team you’re looking for

Power BI has no org chart. People draw one in PowerPoint that is out of date the week after, or use a decomposition tree, which shows one path at a time and no names. The org charts on AppSource slow down or stop at a few hundred people, and none of them let you type a name and find it.

Try Pro free for 14 daysDownload

Free to use, with no watermark and no time limit. Pro from $3 per viewer a year.

The data team sits under ProductHeadcount per unit, search for “data”
Chief executive412Executive officeSales164CommercialProduct131TechnologyOperations117Back officeEngineering84TeamData team27Team+8+5
Light report
The data team sits under ProductHeadcount per unit, search for “data”
Chief executive412Executive officeSales164CommercialProduct131TechnologyOperations117Back officeEngineering84TeamData team27Team+8+5
Dark report

What it shows

Tree draws your organisation as cards joined by lines. Each card has a name, a second line such as a title or department, and a number such as headcount. The number on a manager’s card counts everyone below them too, so the top card shows the whole company. Branches open and close: a “+6” badge under a card says six more boxes sit below it, and a click opens them. A department with many teams stacks them in a column, so the chart doesn’t grow endlessly wide. Type in the search box and the matching cards light up, with their branches opened for you.

How to set it up

Add Tree from AppSource or the .pbiviz file, then drag in:

Unit or person
A unique id per box, such as a unit code or employee number.
Reports to
The id of the box above. Leave it blank for the top.
Name and Subtitle
Optional: the two lines on the card.
Value
Optional: a number per box, such as headcount or cost. Cards show it for the box and everyone below, or for the box alone.
Colour byPro
A field to colour the cards by, such as division or location.
Tooltips
Optional: more measures to show on hover.

Read the full Tree guide

In the report

  • Drag to move around, scroll to zoom, or use the zoom and fit buttons.
  • Hover a card for its value with and without the boxes below, how many boxes are below it, and your tooltip measures.
  • Click a card to filter the rest of the report to that unit and everyone below it (or just the unit); Ctrl+click to pick several.
  • When you select something in another visual, Tree keeps the whole chart and dims the boxes that don’t match.
  • The measure’s number format, light or dark background and high-contrast mode.
  • Tab into the chart and move with the arrow keys; Enter selects, Space opens or closes a branch. Screen readers get each card as an item in a tree with its level.
  • The format pane and messages are in English and Norwegian.

Free and Pro

FeatureFreePro
Cards with name, subtitle and a value rolled up through the branch✓✓
Search with highlight, branches that open by themselves for a match✓✓
Open and close branches, saved in the report; teams stacked in a column✓✓
Pan and zoom, tooltips, filtering by branch, highlights from other visuals✓✓
Keyboard, high contrast, light and dark✓✓
Up to 250 boxes✓✓
Large organisations: more than 250 boxes, up to 30,000—✓
Colour by field: cards coloured by division, location or any field, with a legend—✓
Export view: every branch open and the whole tree fitted, for PDF, PowerPoint and printing—✓

Free features always work, with no key and no tag. Pro features need a licence key for Tree or Everything. Without a valid key, Tree shows the top 250 boxes level by level, plain cards and the normal view, with a short notice and a “Try Pro free” button. A paid key keeps Pro working for 7 days after it runs out, so a late renewal never breaks a report.

Your data stays in your report

Tree makes no network calls and stores nothing outside the report. The licence key is checked inside the visual, so it also works offline, in Report Server and in locked-down tenants.

How the visuals handle data

Pro licence
$36per creator a year
$3per viewer a year

For Tree alone. The entire suite is $90 per creator and $7.50 per viewer, or license the whole organisation.

See pricing

More Grafpoint visuals