Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
The data also works correctly when I'm not drillingthrough.
Solved! Go to 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.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
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.
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.
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
101 | |
88 | |
35 | |
35 |
User | Count |
---|---|
152 | |
100 | |
83 | |
63 | |
54 |