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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Adrian_A
Frequent Visitor

Drill through columns in a sumary fasion

Hello Bi Community,

 

 

Any help would be appreated,

 

Is thier a way to create a drill down function in a table?

For example, lets say i have a column that represents a "Job". The "Job may consist of more than record that takes up 2 lines so, my goal is to expand the job line and see both records OR see both records on one line.

 

 

Thanks,

Adrian

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @Adrian_A ,

According to your description, the function you want to use is drill down, firstly you can learn the concept by the official document: Drill down and drill up in a visual - Power BI | Microsoft Learn

Then I create a sample for your reference. In order to use the drill down function, you should have a table like this:

vkalyjmsft_0-1666851924638.png

From the table can see, Sub_Job C, D and E belongs to Job A, Sub_Job F, G and H belongs to Job B.

Then in a column chart, put Job and Sub_Job in the visual X-axis, you'll find the drill button appears.

vkalyjmsft_1-1666852142804.png

By clicking the drill down button, the visual will show data in the sub level.

vkalyjmsft_2-1666852187327.png

I attach mly sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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

 

 

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @Adrian_A ,

According to your description, the function you want to use is drill down, firstly you can learn the concept by the official document: Drill down and drill up in a visual - Power BI | Microsoft Learn

Then I create a sample for your reference. In order to use the drill down function, you should have a table like this:

vkalyjmsft_0-1666851924638.png

From the table can see, Sub_Job C, D and E belongs to Job A, Sub_Job F, G and H belongs to Job B.

Then in a column chart, put Job and Sub_Job in the visual X-axis, you'll find the drill button appears.

vkalyjmsft_1-1666852142804.png

By clicking the drill down button, the visual will show data in the sub level.

vkalyjmsft_2-1666852187327.png

I attach mly sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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

 

 

Thankyou so much for the Assist! this did the trick!

 

 

- Adrian

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors
Top Kudoed Authors