Hierarchy Slicer Custom Visual

Devin Knight continues his Power BI custom visuals series:

Key Takeaways

  • Let’s you expand and dig into each level of you 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.

This is a great visual if your dimensional data fits a good natural hierarchy.

Related Posts

Blank Rows and DAX

Alberto Ferrari explains how different DAX functions treat blank rows differently: DAX offers two functions to retrieve the list of values of a column: VALUES and DISTINCT. The difference between the two is subtle. To understand it better, we first need to introduce the concept of the blank row. The blank row is a special row added […]

Read More

Power Query and the Benefits of Immutability

Chris Webb explains why immutable expressions can be faster to run multiple times than mutable processes: Instead of taking the value #”Sorted Rows”[Column2]{0} and storing it in the variable Column2 then adding Column2 four times, I’m  adding the expression #”Sorted Rows”[Column2]{0} together four times. The query returns the same number as the previous query. However […]

Read More

Categories