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.
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
