Forum Discussion
How to make drill through from stack bar chart?
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!
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.
7 Replies
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
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.
Is it possible to do the same thing above but it drills to one details page based on the the column (a,b,c).
Anonymous
You can try to first group data then use drill thtrough function.
Best regards
Janey Guo
Thank you so much! I think both answers are awesome. Pragati11 v-janeyg-msft Really appreciate!
