Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Niels_T
Post Patron
Post Patron

Drillthrough is not showing data from other table

Hello,

 

I have a drillthrough on customer names to a different page with customer data.

The data on that particular page contains fields from the customer table and also fields from the credit memo + invoice table.

 

As you can see they are both connected to each.

Niels_T_0-1647529268908.png

 

The data also works correctly when I'm not drillingthrough.

1 ACCEPTED SOLUTION

Sorry I had forgotten that you had posted the data model in the first post. Looks ok.

 

You have to be aware that Drillthrough by default operates on a single field filter being transported from one page to the other. Everything else (including the relationship to the parent table) has to be recreated manually - by you.

 

There is an option you can play with (" Keep all fiters" ) but it might actually be the opposite of what you seem to want to achieve.

 

Another option to consider is to sync slicers between the two pages.

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

@lbendlin 

 

I have a report with retour-data which is presented in a matrix with items -> customer in one column and in the other column the quantity of retours.

Niels_T_0-1647851677219.png

 

 

I would like to drill-through on customer to a different page with more detailed info about the customer.

 

On this page I use data of the customer-table and from the invoice-table.

Niels_T_1-1647851736214.png

On the right you can see that I added customer name to the drill-through filter. And this allows me to actually drill-through. 

 

All the info from the customer-table is then also visible, EXCEPT the invoice data. 

 

As you can see there is nothing under amount. I don't understand why as the tables are correctly connected and I use the customer table together with invoice table in other reports without any issue.

 

 

Please clarify what you mean by "correctly connected".  Is there a 1:* relationship between customer and invoice tables? Single filter direction?

Hello, 

 

Yes there is a 1:* relationship between the two tables. What exactly do you mean with single filter direction? There is only a drillthrough filter on the page where I have to drillthrough to and page filters, but these are not the cause of my problem.

Sorry I had forgotten that you had posted the data model in the first post. Looks ok.

 

You have to be aware that Drillthrough by default operates on a single field filter being transported from one page to the other. Everything else (including the relationship to the parent table) has to be recreated manually - by you.

 

There is an option you can play with (" Keep all fiters" ) but it might actually be the opposite of what you seem to want to achieve.

 

Another option to consider is to sync slicers between the two pages.

So if I understood it correctly:

 

If I do a drill-through I only get to see the data of the parent-table and I can't see the data of other tables even if they are conntected?

yes, unless you do extra work (for example with the RELATED() trick of pulling in dimension attributes into the fact table.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.