Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
RC
New Member

Creating hierarchy from Self joined table

I have a table with folder and document hierarchy, where rows in a table have a parent row in the same table. How can I create the hierarchy in the data model, and show it in a graph, such that the graph shows the top level folders with the total number of descendant folders/documents under it. Also provide a drill down, so that clicking a folder will then show its child folders.

1 REPLY 1
ChrisMendoza
Resident Rockstar
Resident Rockstar

Take a look at https://www.daxpatterns.com/parent-child-hierarchies/#






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.