Drill-through on a Cluster Column Chart

Question

&nbsp;In the picture below, I want to be able to select "39" from EGRF and drill-through to a page that shows me the detail of these 39 rows.&nbsp; I can't seem to get this to work.&nbsp; When I do the drill-through, it shows me all the rows for EGRF.&nbsp; Any help here would be greatly appreciated.&nbsp;&nbsp;

greg_deckler · Answer

Are you left-clicking on the column and then right-clicking and choosing drillthrought? And you x-axis column is in your drillthrough filters on the drillthrough page?

amitchandak · Answer

seem like only want a filter on-axis not on the legend. Then remove legend Keep filter.
Refer:
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough#pass-all-filters-in-drill-through

anonymous · Answer

I already am using the axis and not the legend. And I'm keeping filter. It appears the problem is that I cannot select one of the values that has been clustered in the column. It appears to pass the axis through rather than the specific values. Thanks for looking into this.

v-chuncz-msft · Answer

Anonymous&nbsp;
&nbsp;
Note that details on the focused page are filtered to that context.

anonymous · Answer

I'm sorry I do not follow.&nbsp; What do I need to change to get the functionality that I'm looking for?&nbsp; Is there any additional information that you need from me?

Forum Discussion

Drill-through on a Cluster Column Chart

6 Replies

Related content

Drill Through

Drill Through Limitations

Drill Through Issue

Clustered column chart incomplete legend

Missing Drill Through