Forum Discussion

MURTAZA's avatar
MURTAZA
Resolver I
5 years ago

Drill through stacked column chart

Hi,

 

I have a stacked column chart, created using measures and need to drill through to the details page:

 

 

However, When I click on any of the columns, the full column gets selected, and the drill through shows details of all those values. For example, the first column has a breakdown of 125 + 11 = 136. When I drill through, it shows me details of 136 items. Is there a way to see the details of 125 and 11 separately?

 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Is your legend column part of the drillthrough fields specified in the destination page?

    • MURTAZA's avatar
      MURTAZA
      Resolver I
      5 years ago

      Hi lbendlin 

      Yes, I tried that, but I am unable to select a portion of the column chart. I am not sure if that is even possible for this type of visual.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi MURTAZA ,


    Through the Tooltip function, when the mouse moves to different areas, the detail data of different areas will be displayed. Reference is as follows: 

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

    • MURTAZA's avatar
      MURTAZA
      Resolver I
      5 years ago

      Hi v-henryk-mstf 

       

      Yes, that is correct, it displays separate results, but we need drill through feature for this. In your example, I should be able to see the details for 16M and 12M separately. But right now when I drill through, It shows me details of all 31.82M (referring your screenshot).

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Community Support
        5 years ago

        Hi MURTAZA ,

         

        Currently PowerBI may not be able to perform drill-through analysis on different areas in the same column. But you can post you idea here. Hope to help you solve the problem as soon as possible.


        Best Regards,
        Henry


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