Drillthrough To Disconnected Table

[ken_morrill]

Simple scenario:  Table on a page shows Product, and other attributes from varied statistical sources.

Want: user to select a product from the table, and to drill  to a page showing several visualizations related to Product - but from a completely separate data model that cannot be connected (joined). Would like a page level filter applied that uses the selected Product from the calling report.

Can Power BI do this?

[ken_morrill]

I'm laughing.  When writing this post, I said to self, "please don't let the answer be TREATAS" because despite the number of times I've read up on it, it still eludes me.  😂  Maybe this will be the one use case that pushes me over the hill of understanding!

Thank you!

[lbendlin]

Well, like it or not, but TREATAS is the best answer.  Practice it a couple of times and it will become second nature.

[v-tangjie-msft · Accepted solution]

Hi @ken_morrill ，

Thanks @lbendlin  for the quick reply and solution.

I have some other ideas for you to consider：

Page level filters can only place columns and need to have a model relationship with the columns you want to filter. If you want the slicer table to have no model relationship with the fact table, we can create a measure to be placed on the filter for each visual object.

(1) This is my test data.  

(2) We can create a measure.

Measure = IF(MAX('Table'[Product]) in VALUES('Slicer'[Product]),1,0)

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

[ken_morrill]

This is amazing!  Thank you so much!

[lbendlin]

Read about TREATAS.  It allows you to project the filter from the Drillthrough onto the disconnected table.