Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table of data which has all contacts and another table with all actions related to that contact.
The relationship is one contact_no to many action_cd
All actions have a reference number in the contact table. I have a table that I have filtered to show a specific action if it is overdue but if I click that action I want it to show all related actions using the contact_no. It's kind of working back from the row context.
So when I click on any of these actions I want another table to show me all actions related to the contact_no.
Any help would be appricated. Thanks, Dan.
Solved! Go to Solution.
I don't think that that is possible. When you select a row in your existing table visual, I think that the values for all the columns will be passed to the 2nd table as filters, and that will result in only the selected row being displayed again.
As an alternative you could use either a tooltip or a drillthrough page, passing the contact_no as the parameter.
I don't think that that is possible. When you select a row in your existing table visual, I think that the values for all the columns will be passed to the 2nd table as filters, and that will result in only the selected row being displayed again.
As an alternative you could use either a tooltip or a drillthrough page, passing the contact_no as the parameter.
Thanks for looking though
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
47 | |
46 | |
17 | |
16 |