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: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: