Forum Discussion
Helper VHow to get drilldown or drillthrough the data
Hello,
I have below raw data and chart in one of the report. The requirement is to provide drilldown on chart & table to get the details of the underline bugs.
Raw data :
| WorkItemID | SnapDate | Bug Type | State | Severity | Priority |
| 118537 | 2025-01-01 | L1 | Active | 4 | 2 |
| 173024 | 2025-01-01 | L1 | Active | 3 | 2 |
| 173027 | 2025-01-01 | L1 | Active | 3 | 2 |
| 210732 | 2025-01-01 | L1 | Active | 4 | 2 |
| 226585 | 2025-01-01 | L1 | Active | 3 | 2 |
| 241918 | 2025-01-01 | L1 | Active | 2 | 2 |
| 250470 | 2025-01-01 | L1 | Active | 3 | 2 |
| 118537 | 2025-03-01 | L1 | Active | 4 | 2 |
| 210732 | 2025-03-01 | L1 | Active | 4 | 2 |
| 226585 | 2025-03-01 | L1 | Active | 3 | 2 |
| 241918 | 2025-03-01 | L1 | Active | 2 | 2 |
| 250470 | 2025-03-01 | L1 | Active | 3 | 2 |
| 118537 | 2025-04-01 | L1 | Active | 4 | 2 |
| 210732 | 2025-04-01 | L1 | Active | 4 | 2 |
| 226585 | 2025-04-01 | L1 | Active | 3 | 2 |
| 241918 | 2025-04-01 | L1 | Active | 2 | 2 |
| 250470 | 2025-04-01 | L1 | Active | 3 | 2 |
| 267446 | 2025-01-01 | L2 | Active | 3 | 4 |
| 304541 | 2025-01-01 | L2 | Active | 3 | 2 |
| 305301 | 2025-01-01 | L2 | Active | 4 | 2 |
| 318178 | 2025-01-01 | L2 | Active | 3 | 2 |
| 319040 | 2025-01-01 | L2 | Active | 4 | 2 |
| 320201 | 2025-01-01 | L2 | Active | 3 | 2 |
| 320203 | 2025-01-01 | L2 | Active | 3 | 2 |
| 320510 | 2025-01-01 | L2 | Active | 3 | 3 |
| 267446 | 2025-03-01 | L2 | Active | 3 | 4 |
| 304541 | 2025-03-01 | L2 | Active | 3 | 2 |
| 318178 | 2025-03-01 | L2 | Active | 3 | 2 |
| 319040 | 2025-03-01 | L2 | Active | 4 | 2 |
| 320201 | 2025-03-01 | L2 | Active | 3 | 2 |
| 320203 | 2025-03-01 | L2 | Active | 3 | 2 |
| 320510 | 2025-03-01 | L2 | Active | 3 | 3 |
| 267446 | 2025-04-01 | L2 | Active | 3 | 4 |
| 304541 | 2025-04-01 | L2 | Active | 3 | 2 |
| 318178 | 2025-04-01 | L2 | Active | 3 | 2 |
| 319040 | 2025-04-01 | L2 | Active | 4 | 2 |
| 320201 | 2025-04-01 | L2 | Active | 3 | 2 |
| 320203 | 2025-04-01 | L2 | Active | 3 | 2 |
| 320510 | 2025-04-01 | L2 | Active | 3 | 3 |
I need to provide drill down/drill trhough feature on below charts to pop-up the table will underline bug details.
Hi manojk_pbi
You can do this in Power BI with the Drillthrough feature. Here’s how it works step-by-step:
1. Create a summary chart
- Build a column chart on your main page with Year >> Month >> Bug_Type as the hierarchy on the X-axis.
- Use a measure like:
- Bug Count = COUNTROWS(Bugs)
so you get counts of bugs per month/type.
2. Create a Drillthrough page
- Add a new page and rename it (e.g. Bug Detail).
- Insert a Table visual with fields like WorkItemID, SnapDate, Bug_Type, Severity, State, Priority.
- In the Visualizations pane, go to Drillthrough filters and drag in the fields you want to pass from the chart (for example Month, Year, or even Bug_Type).
- Turn ON Keep all filters.
- Add a Back button (Insert >> Buttons >> Back) so users can navigate back.
3. Test the Drillthrough
- On the main chart page, right-click any bar (e.g. March - Active3).
- Select Drillthrough >> Bug Detail.
- This takes you to the Drillthrough page and shows only the detailed bug rows for that month/type.
End result:
- Page 1 = summary chart (bug counts).
- Page 2 = detail table (only the filtered rows from your selection).
This is why, in my screenshot, when I clicked March >> Active3, the second page showed only those 3 bug records.
8 Replies
rohit1991Super User
Hi manojk_pbi
You can do this in Power BI with the Drillthrough feature. Here’s how it works step-by-step:
1. Create a summary chart
- Build a column chart on your main page with Year >> Month >> Bug_Type as the hierarchy on the X-axis.
- Use a measure like:
- Bug Count = COUNTROWS(Bugs)
so you get counts of bugs per month/type.
2. Create a Drillthrough page
- Add a new page and rename it (e.g. Bug Detail).
- Insert a Table visual with fields like WorkItemID, SnapDate, Bug_Type, Severity, State, Priority.
- In the Visualizations pane, go to Drillthrough filters and drag in the fields you want to pass from the chart (for example Month, Year, or even Bug_Type).
- Turn ON Keep all filters.
- Add a Back button (Insert >> Buttons >> Back) so users can navigate back.
3. Test the Drillthrough
- On the main chart page, right-click any bar (e.g. March - Active3).
- Select Drillthrough >> Bug Detail.
- This takes you to the Drillthrough page and shows only the detailed bug rows for that month/type.
End result:
- Page 1 = summary chart (bug counts).
- Page 2 = detail table (only the filtered rows from your selection).
This is why, in my screenshot, when I clicked March >> Active3, the second page showed only those 3 bug records.
manojk_pbiHello rohit1991 , thanks for your suggestion. I will follow the steps and explore.
If possible pls share me the pbix file.
v-saisrao-msftCommunity Support
Hi manojk_pbi,
Thank you rohit1991, for your insights.
I was able to reproduce your issue on my end and received the following output. I’ve attached the pbix file for your reference.
Thank you.
- manojk_pbi
Hi v-saisrao-msft , thanks for your solution.
Can we have table open in the same page instead going to other page or is there any alternate method to make it more interactive.
- v-saisrao-msft
Hi manojk_pbi,
When you click a bar in the visual, the table can display detailed data dynamically on the same page through visual interactions.
Alternatively, Report Page Tooltips can provide extra context when you hover, though this isn't as interactive as a full table.
Drillthrough always takes you to another page and is best used when you need a dedicated detail page.Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Thank you.
- v-saisrao-msft
Hi manojk_pbi,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
- v-saisrao-msft
Hi manojk_pbi,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.