Free 30-Days trial for xViz visuals here!

Hierarchy Filter for Power BI using xViz

Bhupinder Singh Chadha
October 17, 2019

Note: For the Latest Feature Updates to xViz Hierarchy Filter Power BI Visual, check this blog out!


This month we release 3 new visuals as part of our xViz suite of visuals for Power BI in the Microsoft App Source –

  1.  Advanced Gauge
  2. Hierarchy Filter
  3. Hierarchy Tree

Of which my personal favorite is the Hierarchy Filter.

The Hierarchy Filter is a selector component like a slicer, just that it can display multiple category values in an expandable tree view used to display 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.

Now let’s look at some of the key features of the xViz Hierarchy Filter which would help you easily slice and dice your data by providing a simple hierarchy tree view

Filter Settings – Category Display

You can configure the filter interaction and category display setting using the filter settings.

  1. Single select/ Multi select node selection
    The user can either configure the filter to act as a single select or multi select option.
Hierarchy Filter for Power BI using xViz

2. Category Display Settings
The default category level to be displayed along with no of the hierarchical attributes to be displayed can be configured using the following two properties.

Hierarchy Filter for Power BI using xViz

Display Measure value

Along with the categories, the xViz Advanced Hierarchy filter also gives the option to display measure values. This way one can have a quick snapshot of the most important KPI for each of the category values. For  e.g. you could display sales values for the xViz advanced Hierarchy Slicer for Power BI and conditional format is based on whether it has met the target or not. This way you could quickly focus on the categories which haven’t met the target.

Hierarchy Filter for Power BI using xViz

Appearance Settings

xViz provides a robust set of appearance settings for better styling and interaction capabilities which are listed as follows:

  1. Alternate row Color
    Just like the Table, the advanced slicer for Power BI provides alternate row coloring for better readability.
Hierarchy Filter for Power BI using xViz

2. Selected value customization
It becomes a lot easier as an end-user to quickly identify the selected filter value if it is styled differently from the rest of the items.

Hierarchy Filter for Power BI using xViz

3. Hover customization
Ability to define hover color

Hierarchy Filter for Power BI using xViz

4. Icon Colors
Filter, Search, Search text

Hierarchy Filter for Power BI using xViz

Conditional Formatting

Just like the charts, the Advanced Hierarchy Slicer from xViz can also be conditionally formatted. This property comes in very handy as it helps end-user to spot the outliers quickly and navigate to the pain points. Conditional formatting is part of the pro feature and can be done by assigning a color to both font and background.

Hierarchy Filter for Power BI using xViz

Search Capability

The xViz Hierarchy Filter custom visual provides a search functionality, which allows users to search for a particular value across the complete hierarchy. There are 2 different types of search operations you can choose from

  1. Filter
    Filters the dashboard based on the searched value
Hierarchy Filter for Power BI using xViz

2. Find and Seek
Displays the values being searched without affecting the dashboard

Hierarchy Filter for Power BI using xViz

Runtime options

  1. Clear filter
    Clear all select nodes
  2. Custom context Menu
    The context menu provides you the option to expand/ collapse the hierarchical tree view for easy navigation
Hierarchy Filter for Power BI using xViz


If you feel you are limited with having only one measure value in the hierarchical filter. You could try using the tooltip option in order to display additional information for each of the category fields.


To get the latest version of the custom visual, reach out to us here.

You can take a look at the other advanced custom visuals by xViz here.

About xViz!
xViz is a leading provider of advanced enterprise-grade visuals for Microsoft Power BI. The powerful, intuitive, and customizable data visualization experience of xViz, maximizes the potential of the data and elevates analysis to new heights. This product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as Inforiver, xViz and ValQ.
PBI Certified


5920 Windhaven Pkwy, #130
Plano TX 75093

cross linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram