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.
- 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.
When this add-in is used, it
Can read and make changes to your document
Can send data over the Internet
***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Icons For Your Power BI Reports – Visualization Techniques
Custom Dynamic Segmentation Using DAX In Power BI
***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX
Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase
***** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases