Greetings all,
Hoping you can help with a problem I'm trying to tackle.
My data looks like this:
And I need to develop a chart like this
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?
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.
I attached the pbix you can follow my steps in PQ+ check the drill :
+ 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.
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.
I attached the pbix you can follow my steps in PQ+ check the drill :
+ 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.
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
