Drill through from a cross-highlighted visual

[Joseph_Hchaime]

Hi 

I have this scenario where on one page of a report I have two table visuals. 

When I click on one value of Visual A, Visual B gets cross-highlighted/filtered. 

However when I try to click on the filtered/cross highlighted value in Visual B to drill through from it, it won't let me. 

Can someone help me set it up? or is that feature not available? 

For instance: Table A has Sales by SalesPerson. Table B has Sales by City. 

I want to Click on the SalesPerson's name, then click on a specific City to drill through to details of sales for that specific person for that specifici city. 

[Syndicate_Admin]

In the second screenshot drill thorug pane, you can see that company name is Riyahd filter is applied but not the responisble who should be Ziad el Khoury.

As you can see, the keep all filters option in the drill through menu is grey (not green as in the first screenshot). There is something locking the keep all filters option, may be an ambiguous filter context.

[Syndicate_Admin]

Can you show me some screenshots to undertand exactly what you need exaclty please?

[Joseph_Hchaime]

Screenshot 1:

Screenshot 2:

it should only show me 6 clients and 8 #Matters

[Joseph_Hchaime]

Yes I did. It's not filtering out the records for that specific measure. It's giving me all the measures that are on the end view in the other page. Should it not filter them out since I clicked on only one measure in the source visual? 

[Syndicate_Admin · Accepted solution]

Have you tried holding the control button before selecting visual B value?

That should work to drill down the information for the second visual.

Furtheremore, if you need to show aditional information ina other page you can also try with the drill throug capability of Power BI

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough