Hello all, is there a method to create a drill through with the total of each column? At the moment, I can drill through each segment for each month. But I would like to drill through and take the total to the drill-through page, not the split.
Hi @NewbieJono
Since Drillthrough takes the context filter of the element from which the drill is performed, to get the overall total for each column, you must ensure that this total appears in some form as an element in the graph. For example, you can change the graph type to a combined chart with a line, place the same measure on the line as in the columns, and minimize the visibility of the line, leaving only a marker for the drillthrough purpose.
The pbix with the example is attached
If my answer was helpful please give me a Kudos and accept as a Solution.
Hi @NewbieJono
Since Drillthrough takes the context filter of the element from which the drill is performed, to get the overall total for each column, you must ensure that this total appears in some form as an element in the graph. For example, you can change the graph type to a combined chart with a line, place the same measure on the line as in the columns, and minimize the visibility of the line, leaving only a marker for the drillthrough purpose.
The pbix with the example is attached
If my answer was helpful please give me a Kudos and accept as a Solution.
Hi @Ritaf1983
i am trying to drill through on the total in a matrix visual but its displaying all the values. Individual row drill through is working.
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
