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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AFinster
Helper I
Helper I

Column chart, data, and drill through

Greetings all,

Hoping you can help with a problem I'm trying to tackle.

My data looks like this:

DataData

 

And I need to develop a chart like this

ChartChart

 

I need the chart elements to drill through to detailed data that matches the ID (Name, etc).

Currently the chart is using measures to count the instance of the 6 categories, but that does not help with building the drill through.

Can anyone help with the best way forward?

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @AFinster 

Since the drill needs to receive filter context, it cannot work with measures the way you have defined them.
You need to transform your pivot table into a flat, vertical table.
(This will also help with other analyses.)
Then, the drill will work as expected.

Ritaf1983_1-1739429417481.pngRitaf1983_2-1739429448825.png

 

I attached the pbix you can follow my steps in PQ+ check the drill :

Ritaf1983_3-1739429517839.png

+ see the attached guide :
https://www.youtube.com/watch?v=ESap6ptV8fI

 

 

 

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @AFinster 

Since the drill needs to receive filter context, it cannot work with measures the way you have defined them.
You need to transform your pivot table into a flat, vertical table.
(This will also help with other analyses.)
Then, the drill will work as expected.

Ritaf1983_1-1739429417481.pngRitaf1983_2-1739429448825.png

 

I attached the pbix you can follow my steps in PQ+ check the drill :

Ritaf1983_3-1739429517839.png

+ see the attached guide :
https://www.youtube.com/watch?v=ESap6ptV8fI

 

 

 

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thanks Rita - greatly appreciated!

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