How to Achieve Multi level Hierarchy Drill through

[Iniyavan2007]

Category	Statement
Net revenue	Sales Accounts
Net revenue	Accretion in WIP
Net revenue	Inter Company Transactions
Net revenue	Net revenue
Manpower Costs	Direct Manpower
Manpower Costs	Employee -Performance pay
Manpower Costs	Consultant-CTC
Manpower Costs	Other Manpower Costs
Manpower Costs	Manpower Costs
Outsourcing Charges	Outsourcing UK
Outsourcing Charges	Outsourcing Translation / Text permission
Outsourcing Charges	Intercompany Transactions
Outsourcing Charges	Outsourcing Charges
Other Direct Costs	Leased Line Charges
Other Direct Costs	Consumables
Other Direct Costs	Hire Charges
Other Direct Costs	Electricity Charges
Other Direct Costs	Other Direct Costs
Cost of Revenue	Manpower Costs
Cost of Revenue	Outsourcing Charges
Cost of Revenue	Other Direct Costs
Cost of Revenue	Cost of Revenue
Gross Margin	Net revenue
Gross Margin	Cost of Revenue
Gross Margin	Gross Margin
General Administration Exp	Support Manpower cost
General Administration Exp	Bad Debts & Prior Period Items W/off
General Administration Exp	Sundry balance written Back
General Administration Exp	Fluctuation charges
General Administration Exp	General Administration Exp
Total Expenses	General Administration Exp
Total Expenses	Marketing Expenses - US Office
Total Expenses	Marketing Expenses - UK Office
Total Expenses	Sales manpower
Total Expenses	Marketing Expenses - Others
Total Expenses	Total Expenses
EBITDA	Gross Margin
EBITDA	Total Expenses
EBITDA	EBITDA
Profit Before Tax	EBITDA
Profit Before Tax	Interest
Profit Before Tax	Depreciation
Profit Before Tax	Profit Before Tax
Profit After Tax	Profit Before Tax
Profit After Tax	Provision for Tax
Profit After Tax	Exceptional item
Profit After Tax	Other income
Profit After Tax	Profit After Tax

i have these bar chart 

when i drill down Gross Margin i can see Cost of Revenue and Net revenue. Now i want drill from Net revenue to get Sales Accounts,Accretion in WIP,Inter Company Transactions.

How to drill when i only 2 category in my dataset.

Also I have filter out certain category to see only Net Revenue,GM,EBITDA,PBT,PAT

[Iniyavan2007]

Thank you so much.

[v-junyant-msft · Accepted solution]

Hi @Iniyavan2007 ,

I create a sample dataset myself:

To accomplish your needs, you may want to merge your tables in Power Query now:

After merging, expand the table:

Add a custom column:

Click "Close & Apply":

And then you can create the visual:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.