Drill Through Visualization (Used Relationship)

[ExcelingInLife]

Hello,

I essentially have a current visualization sales dashboard. I use the main sales data to create a map of unique Customers and then the visualization table uses that customer list and has various measures off of that. I then have a drill through to a detail visualization table. From there this used the customer selection from the first dashboard to sort the page, the idea here is to be able to use the main sales data to look at the individual invoice level detail based on the selection. However, despite selecting the customer, the table shows all invoices still, any ideas?

 

[pjmorris]

are you able to share an image of your table links from Powerpivot 'Diagram View'?

It sounds to me that the relationships aren't correct - but I may not be much better informed that you are