Slicer and Visual interaction help

TheShowMustGoOn — Thu, 29 Feb 2024 15:56:46 GMT

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!

Re: Slicer and Visual interaction help

lbendlin — Fri, 01 Mar 2024 21:03:00 GMT

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.

Re: Slicer and Visual interaction help

TheShowMustGoOn — Mon, 04 Mar 2024 09:22:34 GMT

Hello,

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

Thanks!

Re: Slicer and Visual interaction help

lbendlin — Mon, 04 Mar 2024 13:11:49 GMT

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

Re: Slicer and Visual interaction help

TheShowMustGoOn — Tue, 19 Mar 2024 10:17:43 GMT

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

topic Re: Slicer and Visual interaction help in Custom Visuals Development Discussion

Slicer and Visual interaction help

Re: Slicer and Visual interaction help

Re: Slicer and Visual interaction help

Re: Slicer and Visual interaction help

Re: Slicer and Visual interaction help