Forum Discussion
Increasing the Report Granularity to Child Level
I am trying to obtain a below scenario in Power BI. A particular course can be delivered either at parent level or child level. But if one is deployed in parent level then I want to disintegrate them at child level.
Below is the data:
| Training Name | Parent Training | Instructor Hours | Virtual Hours | Self-Study Hours | E-Learning Hours | Total | Category |
| A | 9 | 4 | 5 | 7 | 25 | Sales Training | |
| A1 | A | 2 | 1 | 2 | 3 | 8 | Sales Training |
| A2 | A | 3 | 1 | 3 | 3 | 10 | Soft Skills |
| A3 | A | 4 | 2 | 0 | 1 | 7 | Technical Skills |
| B | 1 | 1 | 3 | 1 | 6 | Negotiation | |
| C | 3 | 2 | 1 | 2 | 8 | Sales Training | |
| D | 4 | 3 | 2 | 2 | 11 | Procurement | |
| D1 | D | 1 | 2 | 1 | 1 | 5 | Forecasting |
| D2 | D | 3 | 1 | 1 | 1 | 6 | Sourcing |
| Training Name | Number of Learners | Date | Total Hours | Category |
| A | 10 | 3/5/2021 | 250 | Sales Training |
| A1 | 5 | 12/4/2021 | 40 | Sales Training |
| B | 13 | 11/6/2021 | 78 | Negotiation |
| D | 2 | 5/3/2021 | 22 | Procurement |
| A2 | 20 | 7/2/2021 | 200 | Soft Skills |
| Training Name | Number of Learners | Date | Total Hours | Category |
| A1 | 10 | 3/5/2021 | 80 | Sales Training |
| A2 | 10 | 3/5/2021 | 100 | Soft Skills |
| A3 | 10 | 3/5/2021 | 70 | Technical Skills |
| A1 | 5 | 12/4/2021 | 40 | Sales Training |
| B | 13 | 11/6/2021 | 78 | Negotiation |
| D1 | 2 | 5/3/2021 | 10 | Forecasting |
| D2 | 2 | 5/3/2021 | 12 | Sourcing |
| A2 | 20 | 7/2/2021 | 200 | Soft Skills |
Thanks
Rahul
2 Replies
Anonymous I'm not clear on your meaning, you want to utterly destroy them at the child level? Can you create an adhoc hierarchy for the Rows in a matrix?
Greg_Deckler I may not necessarily need the data to be broken down at child level. But I want to create a bar chart like the bottom right one which shows learning hours delivered at child category level.
I tried some way to use hierarchy but I am unable to get the result.
