Drill through doesn't work in Power BI

[Analitika]

Hi,

I would like to ask why I don't see drill through option in visual in Power BI. 

Here no option when I right mouse click on the visual.

[Mikelytics · Accepted solution]

Hi @Analitika 

to show the drill through you have to create it first. This is how you do it.

1) Is tart with the following table where i have a Product attribute and a measure

as you can see no drill through

no I create a SECOND page where I put thre measure used in page one into the drill through field

now thre drill through appears in page 1 when I righ-click

after doing the drill through on Prodcut 3 the filter was applied tp the new page

so in the end you have to put a measure or column which is used in visual into the drill through area to another page to be able to drill from the visual page to the other page

when you use a column instead of a measure you additionally have the option to set on and off whether you want to take with you all filters which are applied in the page where you are coming from. if you turn it on ll filters will be taken over. if you turn it of only the product filter will be applied.

when using measure the default behaviour is on

Here you can find more information about drill through

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Anonymous]

Also, as far as I know, cross-report drill-through is only available in PBI Service, and not the desktop version.

[Idrissshatila]

Hello,

You should specify in the drill through page the field you want to drill through to, example : customer, then you right click onj any customer field in any visual and you can see the drill through option.

for more info check this out : https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

If I answered your question, please mark my post as solution, Appreciate your Kudos!