Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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
@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!
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
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).
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
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |