Use a Power BI hierarchy - adhoc created with single fields or pre-defined - as a slicer to filter other report items.

Each level can be expand or collapsed for optimal navigation thru the hierarchy and to find to select (multi or single) the correct attribute from the slicer.

Notes:

Total visible items are limited to +- 30.000 items for optimal performance

There is no limit to the number of levels

Hierarchies with levels that uses multiple columns as key are not supported and can generate incorrect selections

Release notes

[2.2]

Added extra search options[#/LI] [2.1] [#LI]Added support for report page tooltips

Added ctrl selection selection option

Added only leaf selection option

[2.0]

Rewritten to the version API 2.5

Extra options for Ragged Hierarchies

Rewritten filter construction for support for the ISFILTERED() DAX function

[1.3]

Selection is already visible before filter sent to other visuals

Support for ISFILTERED() DAX function

Support for High Contrast modes

Add header Restatement functionality

Add header Outline support

Complete list is available at: https://azurebi-docs.jppp.org/powerbi-visuals/hierarchy-slicer-changelog.html

- Jan Pieter Posthuma, DataScenarios

HierarchySlicer

โดย DataScenarios