Drill Through Report - Passing Different Value

[Anonymous]

Hello Team,

There is a scenario, where I am passing a column to drill through report but the child report should filter the data based on another column.

Below is the example - 

In my source report, I have Property Name which has been passed, but in the child report, I need to show near by properties based on zip code of the selected property (passed from Parent Report).

How we can achieve this?

Regards,

Deepak

[v-shex-msft · Accepted solution]

HI @Anonymous,

Based on test, drillthrough feature only support to pass current value.

Note: Only the field that is in the Drillthrough filters well gets passed through to the drillthrough report page. No other contextual information is passed.

And that's all there is to using drillthrough in your reports. It's a great way to get an expanded view on the entity information you select for your drillthrough filter.

Reference:

Use drillthrough in Power BI Desktop

Regards,

Xiaoxin Sheng

[Anonymous]

Guys,

I want to restrict one of the page level parameter / slicer value to be passed as drill through filter to the detail tab. Any suggestions appreciated. Its weird why I am asking this as passing all paremeters look logical..but this is just in line to replicate the BO reports which works on diff query for different tabs.