cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Drillthrough between two tables

@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.

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Drillthrough between two tables

@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 🙂

YouTube  LinkedIn

Highlighted
Resolver I
Resolver I

Re: Drillthrough between two tables

@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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (821)