need horizontal drill down in Matix Visual for single column

Hi Anonymous,

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!