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.
So I'm trying to utilize one of the hierarchy visuals by creating parent/child hierarchies using the PATH function within DAX.
Basically, I'm dealing with scheduling data laid out similar to this :
Task ID | Predeccesor | Successor
1 5,6,8 4
2 8,12,20 22, 25
3 X, X, X X,X
4 X X,X,X
Each Task in my data set has multiple predeccesors and successors and I want to find a way to create a hierarchy visual connecting all these tasks together somehow. I tried splitting the pred. and succ. by commas into rows, but then the PATH function didn't work because the Task ID showed up multiple times in the dataset. I also am not sure how to get the pred. and succ. to show up as seperate numbers without splitting them by comma.
Is there a way to set this up to make the PATH function work? Or is there another way I can do this to make a hierarchy visual work?
Thank you!
Solved! Go to Solution.
Hi @Jabbajuice ,
Here are the steps you can follow:
1. Enter the Power query and split the columns [Predeccesor] and [Successor] respectively.
Home – Split column – By Delimiter.
Result:
2. Select [Predeccesor1], [Predeccesor2], [Predeccesor3] three columns – Transform – Unpivot Columns.
3. Select [Successor 1], [Successor 2], [Successor 3] three columns – Transform – Unpivot Columns.
Result:
4. Result:
Into the matrix.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Jabbajuice ,
Here are the steps you can follow:
1. Enter the Power query and split the columns [Predeccesor] and [Successor] respectively.
Home – Split column – By Delimiter.
Result:
2. Select [Predeccesor1], [Predeccesor2], [Predeccesor3] three columns – Transform – Unpivot Columns.
3. Select [Successor 1], [Successor 2], [Successor 3] three columns – Transform – Unpivot Columns.
Result:
4. Result:
Into the matrix.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
In order for the Hierarchy to appear on the visuals, one way to accomplish it would be creating groups and subgoups of 'Task'. And then, right click on Task parent and click create herarchy. Once created, add the child groups to this herarchy, and use it on charts to show you the breakdown.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |