Forum Discussion

sofia210's avatar
sofia210
Frequent Visitor
2 years ago

Help Needed: Drill Through Issues

I’m having trouble with setting up drill-throughs in Power BI. I have three tables: Table 0 (client master), Table 1 (case info), and Table 2 (time info). I’ve connected Tables 1 and 2 to Table 0 using unique IDs and created measures. However, when setting up drill-throughs, I’m seeing target pages for Table 2 (time info) even when I’m viewing case counts from Table 1. I need to ensure that clicking on a total cases column only shows drill-through options related to cases, not time tracking. How can I make the drill-through options contextually relevant?

 

Here's a very simplified example of the issue I am encountering.

Need Help

5 Replies

  • sofia210's avatar
    sofia210
    Frequent Visitor
    2 years ago

    Hmm, I don't see anything different. Could you expand?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      you had a 1:1 relationship between a fact and dimension table.

      • sofia210's avatar
        sofia210
        Frequent Visitor
        2 years ago

        I don't think that is the problem. Both measures are in the same visual, and it shows both drill through pages no matter where you click.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sofia210 

     

    According to the information i have, your requirement could not be realized currently..

    Please consider creating a separate visual for each page that needs to drill-through as an alternative solution.

    If you would like to suggest some feature improvements, you can submit it in Home (microsoft.com). It is a place for customers provide feedback about Microsoft Office products.

     

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