Maklum balas Edit

Add multiple fields to a hierarchy slicer

  • Artikel
  • 3 minit untuk dibaca

APPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service

If you want to filter multiple related fields in a single slicer, you do so by building what's called a hierarchy slicer. You can create these slicers in either Power BI Desktop or in the Power BI service.

When you add multiple fields to the slicer, by default it displays an arrow, or chevron next to the items that can be expanded to show the items in the next level.

Screenshot of Hierarchy slicer dropdown in Power B I.

When you select one or more children for an item, you see a semi-selected square for the top-level item.

Screenshot of Single-selection hierarchy slicer in Power B I.

Format the slicer

The behavior of the slicer hasn't changed. You can also style your slicer how you want. For example, you can set it to single-select mode. Or you can swap between a list and dropdown.

Screenshot of Hierarchy slicer formatted as dropdown slicer.

You can also make the following formatting changes.

Change the title

You can edit the title for any slicer, but it's especially useful for hierarchy slicers. By default, the name of a hierarchy slicer is a list of the field names in the hierarchy.

In this example, the title of the slicer lists the three fields in the hierarchy: Category, Commodity, and Item.

Screenshot of hierarchy slicer with Category, Commodity, and Item fields in Power B I Desktop.

To change the name, select the slicer, then select the Format pane. Under Slicer header, you see the current name of the slicer in the Title text box.

Screenshot of the Format pane with the current title in Power B I Desktop.

Select the text and add a new name.

Screenshot of new title for hierarchy slicer in Power B I Desktop.

Change the expand/collapse icon

Hierarchy slicers have some other formatting options. You can change the expand/collapse icon from the default arrow to plus and minus signs, or a caret.

  1. Select the slicer, then select Format.

  2. Expand Hierarchy, then Expand/collapse.

  3. For Expand/collapse icon, select Chevron, Plus/minus, or Caret.

    Screenshot of Select an expand/collapse icon for your hierarchy slicer in Power B I Desktop.

Change the indentation

If space is tight on your report, you may want to reduce the amount you indent the child items. By default, the indentation is 15 pixels, but you can increase or lower that.

  1. Select the slicer, then select Format.

  2. Expand Hierarchy, then Levels. Drag Stepped layout indentation smaller or larger. You can also just type a number in the box.

    Screenshot of Set the hierarchy slicer indentation in Power B I Desktop.

Considerations and limitations

  • When using live connection to SQL Server Analysis Services (SSAS) tabular models and the property hide members in the hierarchy is set to Hide blank members, Power BI doesn't hide blank members. This creates a ragged hierarchy.
  • A ragged hierarchy is also created when there are blank values for a category at any hierarchy level. For example, if Employee A has three levels of management (manager > vice-president > CEO) but does not have a "director", the data table row for Employee A will have three values (names) and one blank. While you can use the Filters pane to deselect blank values for "director", doing so also prevents the other three values from being included in the slicer for Employee A. As a result, Employee A will be removed from the hierarchy slicer.
  • For tabular models, this feature requires SQL Server Analysis Services 2017 or newer.
  • For multi-dimensional models, this feature requires SQL Server Analysis Services 2019 CU5 or newer with SuperDAXMD enabled. Read more about SuperDAXMD.

Next steps