Forum Discussion
Post PartisanDrill Through On Total
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.
Super UserHi 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.