Select Page

Hierarchy Filter for Power BI using xViz

by | Oct 17, 2019 | Hierarchical Filter

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

Introduction

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

  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.xViz Custom Visuals for Microsoft Power BI
  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.xViz Custom Visuals for Microsoft Power BI

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.

hierarchical-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.hierarchical-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.
    hierarchical-filter-for-power-bi-using-xviz
  3. Hover customization
    Ability to define hover colorhierarchical-filter-for-power-bi-using-xviz
  4. Icon Colors
    Filter, Search, Search text
    hierarchical-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.

hierarchical-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
    hierarchical-filter-for-power-bi-using-xviz
  2. Find and Seek
    Displays the values being searched without affecting the dashboard
    hierarchical-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
    xViz Custom Visuals for Microsoft Power BI

Tooltip

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.

Check out the Latest Feature Additions to xViz Hierarchy Filter Power BI Visual, in this blog!

***

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.

Subscribe to Our Newsletter

Related Posts

Get Started with xViz today!

Try xViz to instantly visualize the power of business optimization.