New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

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?
Previous Running totals in power query – Part 1
Next Create allocation table and visualize it in a Gantt Charts with matrix in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents