Column chart, data, and drill through

[AFinster]

Greetings all,

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

My data looks like this:

Data

And I need to develop a chart like this

Chart

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?

[Ritaf1983 · Accepted solution]

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.

[AFinster]

Thanks Rita - greatly appreciated!