Pie chart not filtering table

Question

Hi I am trying to create my own interactive ven diagram where users will be able to select their own range and the diagram will use these parameters to update the numbers. I have used pie charts to show this (As seen in the picture below, this is a draft version as I will be adding the overlaps too)

However when i click on the pie charts I would like the table to also filter out on these products example if i select the 133 group I would like the table to show me those 133 products and if I select the 13 group I would like this table to show me the 13 products.

Are you able to advise me on how I could do this?

Thank you

amitchandak · Answer

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

powerbing1 · Answer

Hi&nbsp;amitchandak&nbsp;&nbsp;Sample data below:Product Code&nbsp; &nbsp; Product Description&nbsp; &nbsp;Store Ranged&nbsp; &nbsp; &nbsp;Stock Cover1213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21423&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33535&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21

Forum Discussion

Pie chart not filtering table

2 Replies

Related content

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Filtering Table report

How to search specific word in table filter Calculations

Filtering line chart with date