Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

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

Let us know your thoughts...

Table of Contents