Filter · Hierarchy

Pick from a hierarchy in one list, and see what you picked

Report pages filter by hierarchies all the time: region, country and city; category, subcategory and product; division, department and team. The native slicer can show a hierarchy, but it has no counts, no way to open the whole tree to one level, and it doesn’t say what is picked once the list is closed. The hierarchy slicer with the most ratings on AppSource (276) hasn’t changed much in years.

Try Pro free for 14 daysDownload

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

Norway, Sweden and Berlin pickedRegion › Country › City
SearchNorway, Sweden, BerlinClearRegion › Country › City▾Nordics8 of 15▸Norway4▸Sweden4▸Denmark3▾Western Europe1 of 18▾Germany1 of 5Berlin
Light report
Norway, Sweden and Berlin pickedRegion › Country › City
SearchNorway, Sweden, BerlinClearRegion › Country › City▾Nordics8 of 15▸Norway4▸Sweden4▸Denmark3▾Western Europe1 of 18▾Germany1 of 5Berlin
Dark report

What it shows

Filter shows your levels as a tree of checkboxes. Tick a region and you pick everything in it; tick a few countries and the region shows a half tick and “3 of 12”, so you see how much of each branch is in. Type in the search box and Filter finds items on every level, opens the way to them and lets you tick all the matches at once. The buttons Region › Country › City open the whole tree down to that level. A line at the top says what you picked, such as “Norway, Sweden, Berlin”, with a Clear link. In Pro, Filter takes more than three levels and more than 1,000 items, and shows a measure such as sales on every row with a small bar, so you can sort by it and pick the biggest.

How to set it up

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

Levels
The columns of your hierarchy, top level first, such as Region, Country and City. Up to three free, up to eight with Pro.
ValuePro
Optional: a measure such as sales, shown on every row and added up through the branch.

Read the full Filter guide

In the report

  • It filters the page like a slicer, and works with bookmarks, Sync slicers and Reset to default. Other slicers filter it.
  • Branches you open are saved in the report, so it opens the way you left it.
  • Arrow keys move through the tree (Right opens, Left closes or goes to the parent), Space ticks, and Down from the search box goes into the list. Screen readers get a tree with levels, open and ticked states.
  • Light or dark background and high-contrast mode. Long lists scroll smoothly, even with tens of thousands of items open.
  • The format pane, the buttons and the messages are in English and Norwegian.

Free and Pro

FeatureFreePro
Tree of checkboxes with half ticks, counts (“3 of 12”) and the picked line with Clear✓✓
Search on every level, select all matches✓✓
Level buttons, Select all, one at a time, open branches saved in the report✓✓
Keyboard, bookmarks, sync slicers, high contrast, light and dark✓✓
Up to three levels and 1,000 lowest-level items✓✓
More levels: up to eight—✓
Large lists: more than 1,000 lowest-level items, up to 30,000 rows—✓
Values with bars: a measure on every row, added up through the branch, sortable by value—✓

Free features always work, with no key and no tag. Pro features need a licence key for Filter or Everything. Without a valid key, Filter shows the first three levels and the first 1,000 items and leaves out the values, 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

Filter 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 Filter alone. The entire suite is $90 per creator and $7.50 per viewer, or license the whole organisation.

See pricing

More Grafpoint visuals