Forum Discussion
Post ProdigyDrillthrough Unpivotted Data
Hi
I need to get from my unpivotted list of field names (below) with the missing entries total thats grouped, to go into a drillthrough.
Just wondering if this is possible and how you would go about creating the link? I can unpivot and group the data no problem, its just finding a link to the raw drillthrough data that I'm struggling with.
I would want to drillthrough Field 1 and see the raw data with 555 lines
Unpivotted Data Example
Thanks
Hi lherbert501
To enable drillthrough from your pivoted summary into the raw data, the drillthrough table must contain the column that creates the filter context – in this case, the Field name.
The raw table should include:
A Field column (e.g., “Field 1”)
An Entry ID or similar unique row identifier
This structure allows the visual to pass the correct filter into the drillthrough page. Power BI uses the filter context from the main visual (e.g., Field = "Field 1") to display only matching rows in the detailed table.
For example, in my case, I have a sales table with one page showing total sales per salesperson (grouped),
and a drillthrough page with a detailed table (unaggregated, using “Don’t summarize”).
When the user clicks a salesperson's revenue, Power BI filters the drillthrough page by that salesperson, thanks to the shared column.In your case, if the raw data contains a Field column and you group the summary by it, Power BI will be able to drill from the summary count (e.g., 555 for Field 1) into the 555 raw rows.
The pbix with the example is attached
More information about drill through is here :
https://www.youtube.com/watch?app=desktop&v=72beG_VHufUIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
- Ritaf1983
Super User
Hi lherbert501
To enable drillthrough from your pivoted summary into the raw data, the drillthrough table must contain the column that creates the filter context – in this case, the Field name.
The raw table should include:
A Field column (e.g., “Field 1”)
An Entry ID or similar unique row identifier
This structure allows the visual to pass the correct filter into the drillthrough page. Power BI uses the filter context from the main visual (e.g., Field = "Field 1") to display only matching rows in the detailed table.
For example, in my case, I have a sales table with one page showing total sales per salesperson (grouped),
and a drillthrough page with a detailed table (unaggregated, using “Don’t summarize”).
When the user clicks a salesperson's revenue, Power BI filters the drillthrough page by that salesperson, thanks to the shared column.In your case, if the raw data contains a Field column and you group the summary by it, Power BI will be able to drill from the summary count (e.g., 555 for Field 1) into the 555 raw rows.
The pbix with the example is attached
More information about drill through is here :
https://www.youtube.com/watch?app=desktop&v=72beG_VHufUIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
lherbert501- Ritaf1983
Happy to help 🙂
v-saisrao-msftCommunity Support
Hi lherbert501,
Have you had a chance to review the solution we shared by Ritaf1983 MFelix? If the issue persists, feel free to reply so we can help further.
Thank you.
- MFelix
Hi lherbert501 ,
I assume that this calculations that you present is some sort of measure or calculation in the power bi report correct?
For this you need to have a drill trough page:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
