Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
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:
Was this helpful?
Reader Interactions