need horizontal drill down in Matix Visual for single column

[yuktadiya]

hi All

Business	Functions	function+1	Percentage
Commercial Operations	Crude	Crude	15
Compliance	Crude	Crude	20
Shipping	STRM	STRM	25
Corporate	Products	Products	35
SEGI & Conference	Products	Products	86
Finance	SET	SEA	20
IT	SET	EPTB	26
Legal	SET	SEAM	79
HR	SET	SEAU	43
CP and CX	SET	EPTB	12
GCC	SET	SEEA	18

1 now in Matrix visual we take Row as Business and Columns as functions and percentage in values. in Functions column if you see for SET lineitems there is subset in functions+1 column. 

2 you can create seaprate Matrix visual for the subset for SET

Row as Business and Columns as functions+1 and percentage in values

Note but here the case is in 1.Matrix visual for SET can we create horizontal drilldown 

for ex  SET (SEA,EPTB,SEAM,SEAU,EPTB,SEEA)

Output 

	CRUDE	STRM	PRODUCTS	SET (here i need a horizontal  drilldown like SEA,EPTB,SEAM,SEAU,EPTB,SEEA)
Commercial Operations	percentage values	percentage values	percentage values	percentage values
Compliance	percentage values	percentage values	percentage values	percentage values
Shipping	percentage values	percentage values	percentage values	percentage values
Corporate	percentage values	percentage values	percentage values	percentage values
SEGI & Conference	percentage values	percentage values	percentage values	percentage values
Finance	percentage values	percentage values	percentage values	percentage values
IT	percentage values	percentage values	percentage values	percentage values
Legal	percentage values	percentage values	percentage values	percentage values
HR	percentage values	percentage values	percentage values	percentage values

Regards

Dilip

[v-priyankata]

Hi @yuktadiya 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@grazitti_sapna Thanks for the inputs

I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @yuktadiya 

I wanted to check if you had the opportunity to review the information provided by user. Please feel free to contact us if you have any further questions.

[grazitti_sapna · Accepted solution]

Hi @yuktadiya,

Firstly create your function heirarchy,

Add these levels in order:

1. Functions

2. Functions+1

then create the MATRIX like below

• Insert a Matrix visual.

• Drag Business → Rows.

• Drag Function Hierarchy → Columns.

• Drag Percentage → Values.

Now enable horizontal drill down by 

• Click on the Matrix visual.

• In the top-right corner of the visual, enable the “Drill mode” toggle (the forked arrow icon).

• Now when you click on SET in the column header, it will expand horizontally to show SEA, EPTB, SEAM, SEAU, SEEA, etc.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!