Drill through to different report for the same visual

[VL22]

Hi All,

I have 2 questions regarding drill through. 

1: I'd like to drill through from a world map to a specific coutry map. For example, from World map, when I click United States, it will drill throught to US Map report. if I click on the China part, it will drill through to China map report. I tried to use "Allow drill through when category is country=>USA," my expectation is: when I click USA and use drill through from the world map, it will drill through to US map, but if I click other countries, they cannot drill through to the US map report. However, it deosn't work. all the coutries on the World map can still drill through to US map report. Does it doable in Power BI? Thank you.

  

2: It seems like if I use coutry as the category to drill through other detail report, all the drill through reports which have the coutry category will show in the list. Is it possible to show only the related drill through report for the specific country? For example, I have two drill through reports, USA MAP and China Map. If I click USA, and click Drill through, only show USA Map.

Thank you so much for your answers.

[v-luwang-msft]

Hi @VL22 ,

You could try yo get it by Use cross-report drillthrough in Power BI Desktop.With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection.

Here is the document for you refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

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

Best Regards,
Lucien

[VL22]

Hi @v-luwang-msft ,

Thank you for your reply. However, the result is still the same...it seems like that as the category is using the same filed, I cannot set up when click USA, then drill thourgh to the USA's map. 

Is there any way to achieve the goal? Thank you!