Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
NCPowerBI
Helper I
Helper I

Creating a Pivot Table with subgroups under main group in Power BI

Hi all,

 

I'm trying to create a pivot table report with subgroups under a main group which Excel usually defaults to when you create a pivot table. I already created a hierarchy with the report to put the subgroup under the main group but I'm still not seeing any drill down options appear to make it happen. I'm not sure if there is another way to do it or if I'm doing something wrong. I pasted an example from Excel on what I'm talking about (censored for privacy concerns). Power BI defaults to tabular format when creating a table so I'm not sure how to get this alternative table format.

 

NCPowerBI_0-1686006285917.png

 

2 REPLIES 2
NCPowerBI
Helper I
Helper I

@amitchandak The drilldown feature is not there (see below) and neither is the stepped layout in the options. Is there something I need to enable or disable in order to make them appear?

 

NCPowerBI_0-1686065624822.png

 

amitchandak
Super User
Super User

@NCPowerBI , Not very clear , but you have an expand button to display data together

 

amitchandak_0-1686019878119.png

 

 

Or use stepped layout off

 

amitchandak_1-1686019918045.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors