How to allow Drillthrough when click category on visual Y axis?

[Anonymous]

I'm having troubles getting my Drillthrough to allow a drill when you select the Y axis of a chart. My chart is displaying a measure and another field. 

When I click on an entire bar in the below example I can do the Drillthrough, so far so good. 

But when I click on a category that is on the Y axis (in this example I click on the category to select both bars) the Drillthrough does not appear. I do have the Field dropped into the drillthrough and the field is on my drillthrough page. What am I doing wrong?

[V-lianl-msft]

Hi @Anonymous ,

At the moment you cannot drillthrough to another report tab with multiple selections. It only works on single selection.So I think you can submit an Idea for a feature request.

https://ideas.powerbi.com/forums/265200-power-bi?WT.mc_id=Community 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous,

From your query, it looks like when you select a category from the Y axis, it actually selects 2 bars (each for different measure or a category, I'm guessing?), the drillthrough occurs for one category at a time, hence it works fine when you select a single value (or a single bar). 

It'll be great if you could share some more details about the visual (the fields which are currently being fed in primary & secondary axis.

[amitchandak]

@Anonymous 

This seems strange. Can you share some sample pbix with sensitive data removed