- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Drillthrough between two tables
Hi,
I have two tables.
the first one contains the models we have, each row contains the model code and its specifications.
the other one, is orders table, each row contains the order number, model code , qty, etc.
there is a relationship between the two tables (model code)
how can I use drillthrough the model code between the two tables?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Fowmy Thank you, but what I wanted was to drillthrough when I have two different tables with mutual column.
What I did was creating a bridge table for the mutual column, made a relationship with the other two tables and used it in the two tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@amaniramahi
Please refer below links to know how to set up a drill-through.
https://www.youtube.com/watch?v=2x9lLHDbtDk
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Fowmy Thank you, but what I wanted was to drillthrough when I have two different tables with mutual column.
What I did was creating a bridge table for the mutual column, made a relationship with the other two tables and used it in the two tables.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-04-2024 01:59 AM | |||
Anonymous
| 04-19-2024 01:27 PM | ||
11-12-2024 02:45 AM | |||
03-18-2019 02:18 PM | |||
09-03-2024 03:39 PM |
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |