Forum Discussion
How to Drill Through
Hi:
Please tell me how to set up a Power BI dashboard to allow the end user to conduct drill through.
Thanks!
John
Hi Anonymous ,
1.There're two pages in the report: Page1 and Page2. Page2 has the visuals you want for the type of entity that you're going to provide drill through for.
In the Page2, put the the column you want to drill through into Add drill through fields.
2.Then you can drill through from Page1, right-click a data point in your report and get a context menu that supports drill through to that page.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
S_JBResolver III
You need to create a hierarchy based on 2 or more fields in your dataset. In desktop you can right click on a field and create new hierarchy, then add the related field to this hierarchy by right clicking on this field and add to the newly created hierarchy.
You can then include this hierarchy in your visual, such as a pie chart, and this can be drilled into to look at the next layer of the hierarchy
- S_JB
You can select the hierarchy as the legend, as this will show as a column in your dataset once it is created.
Add the appropriate field into your values section on the pie chart then you should have drilldown functionality.
- amitchandak
Super User
Anonymous ,
refer is this what you need: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
https://www.youtube.com/watch?v=VBRUiGeV6I4
or do you mean power bi service dashboard ?
Hi Anonymous ,
1.There're two pages in the report: Page1 and Page2. Page2 has the visuals you want for the type of entity that you're going to provide drill through for.
In the Page2, put the the column you want to drill through into Add drill through fields.
2.Then you can drill through from Page1, right-click a data point in your report and get a context menu that supports drill through to that page.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
