Skip to main content

HierarchySlicer

Jan Pieter Posthuma
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 +- 4.000 items for optimal performance
  • There is no limit to the number of levels

Release notes

[1.0.6.0]

  • [FIXED]Small bug fix (unexpected error)

[1.0.3.0]

  • [FIXED]All scrolling issues are now fixed
  • [NEW]Support for ragged hierarchies (Formatting pane: Selection -> Empty Leafs)
  • [NEW]Add ability to show/hide header (Formatting: Header On/Off)

[1.0.0.0]

  • First release to the Office Store

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

- Jan Pieter Posthuma

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680652/Asset_1e1e8e31-5d3c-4f57-8927-c23ebdf00d63/HierarchySlicerUsage.gif
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680652/Asset_1e1e8e31-5d3c-4f57-8927-c23ebdf00d63/HierarchySlicerUsage.gif
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680652/Asset_a2fc3543-4e0c-46f1-b393-b80f7e8d2aef/screenshot1366768.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846986/Product_42949680652/Asset_3b30f392-1ded-44cf-b958-133fb65111ad/screenshot512x384.png