Advanced hierarchies in Power Query

If you want to create hierarchies in Power BI, you need to structure your data in a special way, so they get displayed as hierarchies in Power BI.

In today’s video I will show you how to model your data in Power Query, so your hierarchies are displayed correctly.

Table of contents:

00:00 Intro
00:11 Show data and use case
01:30 Identify the different hierarchy levels on a custom column
03:00 Identify where each level starts in a new custom column
05:50 Show the new hierarchy in a slicer in Power BI

Watch the tutorial:

Links to the mentioned resources

Link to advanced fill down: