Hierarchical Filter
For Microsoft® Power BI
The Hierarchical Filter for Power BI 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 in the custom visual can be expanded and collapsed for optimal navigation through the hierarchy and single/ multiple selections can be made to select the desired nodes. Advanced customization options include conditional formatting, customization of appearance settings for better styling and interaction capabilities.
Features
Conditional Formatting
Visually highlight the areas by assigning specific colors to both font and background based on different business rules
Search
Easily search across the complete hierarchy instead of scrolling to the desired node
Context Menu
Runtime options for easier navigation like expand/ collapse all nodes and expand to a desired level
Appearance Customization
Detailed Styling options for overall appearance, parent nodes, hover and select interaction
Filter Type
Choose between a Dropdown or List box to better optimize your dashboard real estate usage
Node Selection and customization
Choose between single or multi-select node selection options and hide empty nodes in case of unbalanced hierarchies
Value and Category Display settings
Set the default category level and members being displayed along with the child count for each node
Tooltips
Display additional information for each of the hierarchy nodes in Hierarchical Filter for Power BI
For any feature requests or questions about this advanced custom visual, please write to us at community.xviz.com
Use Cases
Display sales values for the hierarchical filter and conditional format them 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.
Helps you filter complex hierarchical data categorically that can be analyzed through selections from the filter
Visually engage hierarchical folder structure along with its sub-elements
The table below gives an idea of the exclusive features for visuals shipped in the Pro version of xViz suite.
| Pro Features | Variance Chart | Multiple Axes Chart | Hierarchical Tree | Hierarchical Filter | Hierarchical Variance Table | Linear Gauge | Advanced Gauge | Gantt Chart | Bullet Chart | Parallel Coordinates | Marimekko Chart | Horizon Chart | Tag cloud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Number Formatting | - | |||||||||||||
| Adv.Editor/Conditional Formatting | - | - | - | - | - | - | ||||||||
| Sort by anything other than default value | - | - | - | - | - | - | - | - | - | - | ||||
| Limited to 10 data series | - | - | - | - | - | - | - | - | - | - | - | |||
| Customize plot area width | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Show average | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Expand On-Demand | - | - | - | - | - | - | - | - | - | - | - | |||
| Hide absolute,percentage variance,comparison/actuals | - | - | - | - | - | - | - | - | - | - | - | - | ||
| No. of orienations,min/max angle,Remove special characters,Split words | - | - | - | - | - | - | - | - | - | - | - | |||
| Qualitative Comparitive Bands | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Target Marker Customization | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Data label-Height and width | - | - | - | - | - | - | - | - | - | - | ||||
| Using Height and width | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Context menu | - | - | - | - | - | - | - | - | - | - | - | |||
| More than 3 categories, Search, Using time period, Max 200 rows | - | - | - | - | - | - | - | |||||||
| Using more than 2 measures | - | - | - | - | - | - | - | - | - | - | ||||
| Gauge options (Entire Section) | - | - | - | - | - | - | - | - | - | - | - | |||
| 3-D Mode | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| Custom Data Labels | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Find & Seek Search | - | - | - | - | - | - | - | - | - | - | ||||
| Filtering through Search | - | - | - | - | - | - | - | - | - | - | ||||
| Multi-mode visual | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Minimap Feature | - | - | - | - | - | - | - | - | - | - | - | - |
Get Started with xViz today!
Try xViz to instantly visualize the power of business optimization.
