Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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):
ID | Name |
1 | Task 1 |
2 | Task 2 |
3 | Task 3 |
4 | Task 4 |
5 | Task 5 |
6 | Task 6 |
7 | Task 7 |
Table 2 (LINKS)
PARENT | CHILD |
1 | 2 |
2 | 3 |
2 | 4 |
5 | 6 |
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 1 | Task 2 | Task 3 | |
Task 1 | Task 2 | Task 4 | |
Task 5 | Task 6 | ||
Task 7 |
Hopefully someone could help to guide into the right direction.
Many thanks
Joerg
Solved! Go to Solution.
@JoergSch , merge table 1 and 2 using ID and Child in Power query
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Then use path in DAX to get it
example of path
@JoergSch , merge table 1 and 2 using ID and Child in Power query
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Then use path in DAX to get it
example of path
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |