Hierarchical Filter – xViz

Displays multiple category values in a tree structure as filter

The Hierarchical Filter is a selector component like a slicer, just that it can display multiple category values in an expandable tree view used to displayed hierarchical nodes for filtering. Each node can be expanded and collapsed for optimal navigation through the hierarchy and single/ multiple selections can be made to select the desired nodes.

Configuration options include conditional formatting, customization of appearance settings for better styling and interaction capabilities and configuring the filter interaction and category display setting using the filter settings.


  • Single select/Multi select node selection.
  • Category Display settings.
  • Display measure value.
  • Customization of appearance- Hover customization, alternate row color, icon color.
  • Search capability.
  • Conditional Formatting.
  • Custom context menu.
  • Tool-tips. 


  • Display sales values for the hierarchical filter and conditional format is based on whether it has met the target or not.
  • This allows you to get a quick snapshot of the most important KPI for each category.

Add-in capabilities

When this add-in is used, it

Can read and make changes to your document

Can send data over the Internet