Using pie chart of value ranges to filter table with single values

[clairem]

Ok, so this is a bit hard to explain, so I hope this makes sense. I'm also a first-time poster, so please bear with me

I'm creating a dashboard that uses Net Promoter Score statistics. In Net Promoter, a survey respondent gives a rating that falls within 0 and 10, and the rating is used to categorise them as either a detractor (rating <=6), a passive (rating 7 or 8), or a promoter (9 or 10). I've created a pie chart that shows the percentage of these categories, and I have a table that shows each individual rating with any comments the respondent gave. I would really like it if I could select a category on the pie chart, and have it filter the table to show only the entries that fall within the rating range. Is this possible? I can't figure out how to do it.

The tables I'm using are laid out like this:

Pie Chart:

Columns: Month, Detractor, Passive, Promoter

Row names are sorted by month, and each row shows the number of detractors, passives, and promoters who responded within that month

I have a Month slicer for the pie chart which will eventually work on the table too once I've added a column

Table:

Columns: Respondent ID,Date, Rating, Comment

Rows: Each row is a unique response

[v-yuta-msft · Accepted solution]

@clairem ,

I would suggest you to create an additional slicer chart besides pie chart and table chart. The slicer chart should be based on the category column, when you want to see positive rating, you can select 7, 8, 9, 10(range) in the slicer, and then select a specific category in pie chart, then the table chart will be filtered as your requirement.

Community Support Team _ Jimmy Tao

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