Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Drillthrough To Disconnected Table

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?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ，

     

    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. 

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ，

     

    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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      This is amazing!  Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      lbendlin
      Super User
      2 years ago

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