---
title: Power BI Custom Visuals - Hierarchy Slicer
description: The Hierarchy Slicer Power BI Custom Visual is a great way to filter your data within a hierarchical view.
---

[Pragmatic Works Nerd News ](https://pragmaticworks.com/blog)

# [Power BI Custom Visuals - Hierarchy Slicer](https://pragmaticworks.com/blog/power-bi-custom-visuals-hierarchy-slicer)

 Written by [Devin Knight](https://pragmaticworks.com/blog/author/devin-knight) | May 18, 2017

In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual.  The Hierarchy Slicer visual is a great way to filter your data within a hierarchical view.

### Module 51 – Hierarchy Slicer

### Downloads

- Power BI Custom Visual – [Hierarchy Slicer](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Ejn3BZIKy-NHk0DHsQUqT5QBx8WaO5HCyu0Qo7pWOzaWmw?e=ktbenN)
- Dataset – [Product Hierarchy Sales.xlsx](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/EmsYPFXLGRVIj3bTbFwNl1AB6yRokke7M563NNa8ViL8Fw?e=cZRwUr)
- Completed Example – [Module 51 – Hierarchy Slicer.pbix](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/EmsYPFXLGRVIj3bTbFwNl1AB6yRokke7M563NNa8ViL8Fw?e=cZRwUr)

### Key Takeaways

- Lets you expand and dig into each level of your hierarchy data.
- Allows you to display a measure value at the lowest level.
- Replaces the idea using multiple regular slicers to represent what the Hierarchy Slicer does.

<https://devinknightsql.files.wordpress.com/2017/05/image4.png>

*In this Hierarchy Slicer we’re showing the ability to filter down a product hierarchy.*

- Under the **Format** paintbrush there are a few customizations available for the Hierarchy Slicer.
- Under the **Selection **section you can choose to turn on the ability to multi-select values in the Hierarchy (by default it’s set to single select).

<https://devinknightsql.files.wordpress.com/2017/05/image5.png>

- The **Header** section allows you to change the slicer Title and adjust other formatting settings of the title.

<https://devinknightsql.files.wordpress.com/2017/05/image6.png>

- The **Items** section allows you to adjust the formatting of the hierarchy values.

<https://devinknightsql.files.wordpress.com/2017/05/image7.png>

In addition to these properties, there are settings that appear on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

### Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On-Demand Training platform or [view my previous blog posts](https://blog.pragmaticworks.com/topic/power-bi-custom-visuals).

[View full post](https://pragmaticworks.com/blog/power-bi-custom-visuals-hierarchy-slicer)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Devin Knight"
  },
  "dateModified" : "2023-03-28T17:17:45.389Z",
  "datePublished" : "2017-05-18T20:13:09Z",
  "headline" : "Power BI Custom Visuals - Hierarchy Slicer",
  "image" : {
    "@type" : "ImageObject",
    "height" : 200,
    "url" : "http://blog.pragmaticworks.com/hubfs/Banners/Power-BI-Banner.jpg",
    "width" : 600
  },
  "mainEntityOfPage" : "https://pragmaticworks.com/blog/power-bi-custom-visuals-hierarchy-slicer",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://blog.pragmaticworks.com/hubfs/PW%20Logo-2.png",
      "width" : 217.56097
    },
    "name" : "Pragmatic Works Blog"
  }
}
```