Skip to main content
Microsoft Idea

Power BI

Needs Votes

Matrix Table Selective Drill-Down

Vote (10) Share
John O.'s profile image

John O. on 07 Jul 2017 06:02:35

I desperately need the ability to create pivot tables similar to those in Excel. More specifically I want to be able to have two row fields where I can collapse to only show the left row field or expand to show the breakdown by the right row field.

For example, I have sales info that i break down by Segment and Geography. Lets say we have Segments (Tech, Government, and Manufacturing) and GEOs (East, Central, West). I want the ability to have Tech with a subtotal and its breakdown by East Central West, WITH Government below it Subtotaled without the GEO breakdown.

Tech East x
Central x
West x
Tech Total x
Government Total x
Manf. East x
Central x
West x
Manf. Total x