How to make drill through from stack bar chart?

[wulawula]

Hello,

I made a stack bar chart and want to make drill through to the detail page. It seems the drill through only works for the whole bar. For example, the drilled through detail now shows 306+241+33+92+472. But I want to just show the category I click, like 92 details. Is there any solution for that? Thank you so much!

[Anonymous]

Hello,

For me its the opposite and I cant figure out how to drill through on the whole column. My goal is to drillthrough on multiple columns in a stacked column chart. Any ideas?

Thanks

[v-janeyg-msft]

@Anonymous 

You can try to first group data then use drill thtrough function.

Best regards

Janey Guo

[wulawula]

Thank you so much! I think both answers are awesome. @Pragati11 @v-janeyg-msft  Really appreciate!

[Pragati11]

Hi @wulawula ,

If both the solutions have helped, please mark both of them as solution to this thread. This will help others in future to get the appropriate answer for the similar query.

Thanks,

Pragati

[v-janeyg-msft · Accepted solution]

Hey, @wulawula

It's a pleasure to answer for you.

The drilling page is designed by yourself. Place the field you want to explore on the landing page, and you can drill down from other pages where there are related fields.

Like this:

Here are some reference documents:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

If you do not solve your problem, please feel free to ask me.

Best regards

Janey Guo

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

[sandrasmith]

Is it possible to do the same thing above but it drills to one details page based on the the column (a,b,c).

[Pragati11]

Hi @wulawula ,

For a selection on a values, try using drillthrough buttons:

https://www.c-sharpcorner.com/article/create-a-drill-through-button-in-power-bi/

This gives you capability to drill on a single value selection.

Thanks,

Pragati