Forum Discussion
hierarchy in multiple tabels
Hello guys, I am new to this subject and I was wonderig if I could get some help from you!
So I am now working on a dataset that is about some tasks that a company has to do. There is a table with all the details of each task like this:
Tasks
| TaskID | Description | NumberOfWorkers | ExpectedTime |
| 1 | Clean something | 1 | 1h |
| 2 | Fix something | 2 | 2h |
But then there are some tables regarding the risks that each task can have, as well as "sub-risks". For exemple:
MechanicalRisks
| TasksID | ObjectsFall | Perfuration | Projections |
| 1 | TRUE | FALSE | TRUE |
| 2 | FALSE | FALSE | FALSE |
FireRisks
| TasksID | ElectricalOrigin | FuelOrigin | GasOrigin |
| 1 | TRUE | TRUE | TRUE |
| 2 | FALSE | TRUE | FALSE |
The tables are connected this way:
Tasks[TaksID] 1 - 1 MechanicalRisks[TasksID]
Tasks[TaksID] 1 - 1 FireRisks[TasksID]
I would like to create a sunburst graphic like this one:
Where the area would be MechanicalRisks, FireRisks and the Category would be ObjectsFall, Perfuration and Projection for the MechanicalRisks' Area and ElectricalOrigin, FuelOrigin, GasOrigin for the FireRisks' Area.
The values would be regarding the count of TRUE values.
Can you help me out? I can't creat a hierarchy, neither creating a measure for the values.
Thank you so much in advance!
Hi Anonymous ,
Here are the steps you can follow：
1. Enter the power query, Home – Merge Queries – Merge Queries as New
Result:
2. Select [TaskID] in the Merge1 table and click Tramsform – Unpivot Columns - Unpivot Other Columns.
Result:
3. Create measure.
Flag = COUNTX(FILTER( 'Merge1','Merge1'[Value]=TRUE()),[Attribute])4. Result:
Choose Donut chart.
Display the count of Task ID grouping as True:
Click Drill down to display the next level. When grouping by Attribute, the count is True.
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
2 Replies
Hi Anonymous ,
Here are the steps you can follow：
1. Enter the power query, Home – Merge Queries – Merge Queries as New
Result:
2. Select [TaskID] in the Merge1 table and click Tramsform – Unpivot Columns - Unpivot Other Columns.
Result:
3. Create measure.
Flag = COUNTX(FILTER( 'Merge1','Merge1'[Value]=TRUE()),[Attribute])4. Result:
Choose Donut chart.
Display the count of Task ID grouping as True:
Click Drill down to display the next level. When grouping by Attribute, the count is True.
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