Print

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:

How to create hierarchies in Power Query

Links to the mentioned resources

Link to advanced fill down:

Advanced fill down scenarios with Power Query
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents