Show filtered values in graph based on other filtered graph

[Divous]

Hi community,

I have three tables. List of customers, list of vendors and list of eaten customer's fruit. 

My goal is to find out how many customers eat what fruit at which vendor and where (in which competition) they eat other fruits. It should be just a comparison of how the customers of a particular company behave. I will show you screenshots for understanding.

Default view with filters per fruit:

Now I want to see how many customers who eat Cherries at "Fruit & co", eat other fruit and at what competition, but I don't see anything:

However, from a data source I know well that customers who eat Cherries at "Fruit & co" eat some apples also at the competition. But which and how many are there?

Can you help me? I'm probably missing basics, but I don't know what to do with it.

All files here on GDrive 

Thanks in advance!

[v-eqin-msft · Accepted solution]

Hi @Divous ,

How about this:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohammedadnant]

Hi @Divous 

It will be great if you can share the table structure,

if all are on the same table, I prefer to use the slicer to filter the "Fruit & co" etc

[Divous]

Hi @mohammedadnant 

no, its in separate tables.. All files (pbix, xlsx) is there https://drive.google.com/drive/folders/1MffF-o27ifGxGyHQe64G0Hiw6SAGR-br?usp=sharing

[mohammedadnant]

Hi @Divous 

Thanks for sending the detail,

I have used vendor in a slicer as below and it looks good

[Divous]

Hi @mohammedadnant ,

thanks for your reply!

This is not what I mean. 

I mean - case - I am "Fruit & Co." and I have customers who eat Cherries and I am curious about my customers (who eat Cherries from me) what they eat at other companies. So I click in Cherry pie chart on my name "Friut & Co." and want to see (my customers who eating Cherries) where they eat other fruits.
Look on second screenshot in Topic, please.