Forum Discussion

AFinster's avatar
AFinster
Helper I
1 year ago
Solved

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:

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?

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    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.

     

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    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.