Increasing the Report Granularity to Child Level

[Anonymous]

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

[Anonymous]

@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.

[Greg_Deckler]

@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?