Power BI Hierarchy slicer

Hierarchy Slicer

Hierarchy slicer

The hierarchy slicer for Power BI provides the opportunity to simple select multiple members of different levels of a hierarchy as selection. The slicer can be used with an existing hierarchy or a manual created hierarchy.

Example

See here for an example if the embedded version is not working.

Data Fields

The HierarchySlicer needs data it a specific way

  • Fields - These fields are the base of the hierarchy. Each field will represent a level in the hierarchy
  • Values - With a value it is possible to (pre)filter the hierarchy to show only members that have a value. Typical scenario: filter a product/category hierarchy with sales. The values are not shown in the visual

Selection

With the selection option the behavior of the hierarchy can be changed

  • Single Select - When set to true (default) only one member of the hierarchy can be selected. When set to false a multiple selection is possible. Note: Ctrl select is not working.
  • Empty levels - When set to true enables the hierarchy to support ragged version. If a level is 'empty' than the lower levels are ignored.

Basic formatting of the header is possible in this section.

  • On/Off - Enable the header
  • Title - Enter a custom header
  • Font Color - Font color used for the header
  • Background - Background color for the header
  • Text size - Text size used for the header

   

Items

Basic color formatting of the items

  • Font Color - Font color used for the items
  • Select Color - Font color of the selected items
  • Background - Background color for the items
  • Text size - Text size used for the header

Changelog

See for the list of changes here.

Comment?

Feel free to comment and suggest features via the GitHub repository or via the comments below.

Current open issues


Share This Post
Twitter Google+ Pinterest Facebook