Slicer to filter for products bought in future transactions

[Anonymous]

Hi all, I'm trying to perform a sales analysis. "Given customers bought product X in their first purchase, what do they buy in their subsequent purchases?"

I have a table of sales transactions, and the serial number of the transaction (corresponding to each customer). What I want to do is allow the user to select a starting product (aka SKU) from a slicer, and then show a bar chart of popular SKUs bought in their subsequent purchases.

I think the answer is somewhere around here, but I'm not sure how to implement it... any help would be much appreciated!

I have attached the sample excel file here.

[v-juanli-msft]

Hi @Anonymous

From your dataset, I can't see how to create relationship between "Products" and "Table1" tables.

Best Regards

Maggie

[Anonymous]

Let me give further example, if let's say a customer buys product X in her first purchase, and Products A, B, C in her subsequent purchases, then I can create a stacked bar chart where:

x-axis = all customer's n-th purchase

y-axis = sum of quantities of products purchased

legend = product name (A, B, C with red, blue, green color respectively)

or I can also create a pie chart showing percentages for second, third, nth purchases only.

How do I do this?