Slicer and Visual interaction help

[TheShowMustGoOn]

Hi,

I'd like to show product crossover as a visual, let's say a funnel, which will show me the product with the highest crossover with the one I've selected at the top, down to the lowest at the bottom. I'm having trouble using slicers to get the funnel to show this correctly.

Example data - first 2 columns are an example of the data I'm providing, others show table form of how to present it (product crossover % is how the funnel should show).

I'm looking at the product APPLES and seeing what other products, the customers who purchased apples also purchased.  All of them purchased Oranges, 50% of them purchased bananas, 25% of them purchased pears and plums.

Customer ID	Product			CUSTOMER DISTINCT COUNT	PRODUCT CROSSOVER
A	APPLES		APPLES	4	100%
B	APPLES		ORANGES	4	100%
C	APPLES		BANANAS	2	50%
D	APPLES		PEARS	1	25%
A	BANANAS		PLUMS	1	25%
B	BANANAS
C	PEARS
D	PLUMS
A	ORANGES
B	ORANGES
C	ORANGES
D	ORANGES

I want to filter the visual by the customers who purchased product name APPLES. But still show all the other products.

- When I have a funnel visual with product name (category) and distinct customer ID count (values) it shows number of customers per product for my whole database as expected

No slicer filter selected

- When I add in a slicer for product name, the funnel only shows the customer count for that one product

- I added in another slicer for customer ID and have all selected, with a card to show customer count, this changes as I select product.

- I have edited interactions so the product name slicer does not filter the funnel visual, but the customer ID slicer does - in theory I hoped this would mean the funnel would only show products for the customer ID's in the second slicer. It doesn't, it remains as the whole database.

- If I use the customer ID slicer to multiple select customers, it does what I want it to do. But I want to do that by product not by customer ID.

I need the product slicer to power the customer slicer, which then powers the visual... but still shows non-filtered products?

Any ideas?

Thanks!

[TheShowMustGoOn]

Thank you. I'm learning as I go along so I appreciate your help. This now works as I wanted it to.

[TheShowMustGoOn]

Hello,

Customers and products are in the same table in my example, 2 columns. So no relationships etc. 

Thanks!

[lbendlin · Accepted solution]

Invest in a data model. Won't work with a single table.

[lbendlin]

 Does your data model look like this?

Your sample data and your expected outcome don't seem to match. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.