Forum Discussion
Post PartisanDrill Through On Total
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.
2 Replies
- Ritaf1983
Super User
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.
