https://store-images.s-microsoft.com/image/apps.45778.423db936-c26b-4e15-84fe-8abc0b729387.42c3fe9e-7d92-4480-a4f2-45b80779ccfc.4900cc81-c8ef-46ad-9413-ae7dea24a2ce.png
Create a hierarchy of different fields and use it as a slicer with Power BI.
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
Visual capabilities
This visual is certified by Power BI
At a glance
https://store-images.s-microsoft.com/image/apps.51749.423db936-c26b-4e15-84fe-8abc0b729387.42c3fe9e-7d92-4480-a4f2-45b80779ccfc.7ddd86f5-bb21-472a-90b6-f206bb3b1b6b.png
https://store-images.s-microsoft.com/image/apps.30218.423db936-c26b-4e15-84fe-8abc0b729387.42c3fe9e-7d92-4480-a4f2-45b80779ccfc.42b0dab2-09f2-49f6-a4b4-016d8f1b7f20.png
https://store-images.s-microsoft.com/image/apps.33331.423db936-c26b-4e15-84fe-8abc0b729387.42c3fe9e-7d92-4480-a4f2-45b80779ccfc.d1a424a2-587a-44e1-a56b-160b7dea5075.png
Other apps from DataScenarios
Box and Whisker chartDataScenariosVisualize a dataset in an effective way as a five-number summary (mean, median, quartiles, min/max)
+1
Applicable to:
Power BI visuals
NaN out of 3
D3.js Visual - create your own custom visualDataScenariosBring your data to life by using HTML, SVG, CSS via the D3.js framework and create your own visual.
+1
Applicable to:
Power BI visuals
NaN out of 3
Event ViewerDataScenariosThe Event Viewer chart visualizes device events over time. Ideal for IoT devices that report states.
+1
Applicable to:
Power BI visuals
NaN out of 3