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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JoergSch
Frequent Visitor

Hierarchy Table

Hello,

 

I need to build up a hierarchy table visual which shows me a task and its subtasks, whic could have multiple levels.

 

I have 2 tables.

 

Table 1 (Tasks):

IDName
1Task 1
2Task 2
3Task 3
4Task 4
5Task 5
6Task 6
7Task 7

 

Table 2 (LINKS)

PARENTCHILD
12
23
24
56

 

Task 1 has a child (2), which has 2 childs (3 and 4). Task 5 has a child (6). Task 7 has no child.

 

Result:

Task 1Task 2Task 3 
Task 1Task 2Task 4 
Task 5Task 6  
Task 7   

 

Hopefully someone could help to guide into the right direction.

 

Many thanks

 

Joerg

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.