Docs · Visuals
Filter guide
Pick from a hierarchy in one list, and see what you picked.
Fields
| Field well | What to put in it |
|---|---|
| Levels | The columns of your hierarchy, top level first, such as Region, Country and City. Up to three free, up to eight with Pro. |
| Value (Pro) | Optional: a measure such as sales, shown on every row and added up through the branch. |
Set it up
- Add Filter to the report page (see Install the visuals) and drag in the fields above.
- In Format › Selection, choose one at a time (radio buttons instead of checkboxes) and switch the search box, Select all, the level buttons and the picked line on or off.
- In Format › Rows, pick how many levels are open when the report opens, the order (as in the data, by name or by value) and whether counts and bars show.
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.
Pro features
- 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
Pro features need a licence key for Filter or Everything, or a 14-day trial key. 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 above the chart and a “Try Pro free” button. Everything else keeps working. See Add your licence key.
Something not right?
Check Questions and answers, or write to support@getgrafpoint.com saying which visual and where the report runs (Desktop, the Power BI service or Report Server), with a screenshot made with sample data.