Drilldown - Pass data from a visual to a different field for drilldown on the details page

[hmeltonPSL]

I have a visual on my main page that I would like to use to drilldown on my details, however field name is different on the details page.

I have a table showing a workitem id and I want to pass that workitemid to the parentworkitem id field on my details page for drilldown. For example,

workitem id	title	parent id	type
1	myfeature		feature

workitem id	title	parent id	type
123	myuserstory	1	user story

Is this possible?  Thanks

[v-yueyunzh-msft · Accepted solution]

Hi, @hmeltonPSL 

According to your description, you want to transfer [workid] to [parentid] of the next detail page in your main page.
For the default drill through, the same fields are required for drill through.
You can try to use the synchronous slicer and then use the button to jump to your detail page to achieve your needs.

Here are the steps you can refer to :
(1)This is my test data:

(2)We can put the 'Table1'[workid] and button in the first page:

We need put the 'Table2'[parentid] in the sencond page:

Then we can put two slicers as the same group , so when i select the first slicer in 1st page , the slicer in 2nd page will also be selected and we can also hide the 2nd slicer :

For the sync slicer you can also refer to :
Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn

And last we need to configure the action for the button in 1st page:

Then we can select the [workid] we need on the first page, and then click the button to jump to our detailed page.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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