Azure BI

Power BI Visuals
VSTS Extensions
VS Code Extensions
Community Events
About Me

Power BI Hierarchy slicer

6 years ago
2 min read

Hierarchy slicer

Hierarchy SlicerThe 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.
  • Select All - When enabled there is a 'Select All' member the select (or deselect) all the available members.
  • Select All Label - If the 'Select All' option is enabled this option can be used to alter the label of this member.

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/requests

This page will move to a new side and the current comments will not be migrated. Please use https://azurebi-docs.jppp.org/powerbi-visuals/ if you have any comment to be sure that it will survive the migration

By: 
Jan Pieter Posthuma
© 2022 Azure BI (Jan Pieter Posthuma)
Lovingly made in 
Lovingly made in 'de Achterhoek'