Two clustered column chart will filter a table

[Kalachuchi]

So I have  two clustered column chart and a table which shows the details.

The first column chart shows the top 20 stores

and the second column chart shows the products from the stores.

So for example I clicked Store A from the first column Chart then  it will filter the second column chart on which product that the store sells.

I did this by using edit interaction,

After clicking the second chart it should also filter the table showing the clicked store and clicked product.

Goal is to when I click Aguho on the Store column chart it is filtering products of Aguho but when I click on Apple, it should only filter the table Store = Aguho Product = Apple

[v-jayw-msft]

Hi @Kalachuchi ,

Are these field from same table or different tables? What's the relationship between them.

Can you share some sample data please?

Best Regards,

Jay

[Kalachuchi]

@v-jayw-msft Hello, Yes it is only the same table.

[amitchandak]

@Kalachuchi , Seem like the filter is working, but some problems in the relationship, because all value is the same.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Kalachuchi]

@amitchandak  based from the image above, both culstered column chart will filter the table. Click 'Aguho' -> Shows the values of products under aguho and when you click a specific product for exaple 'Grapes' Will show 

Image above shows highlighted = 'Poblacion' but when i click on Banana on clustered chart of product it should only show banana and poblacion on the table excluding other products.