Forum Discussion
Pie chart to filter table
Super UserCPC-Keith , Please check interaction is enabled from pie to other visual
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Else need to check the model for filter direction.
If this does not help
Can you share a sample pbix after removing sensitive data.
Taken a look at the interaction settings,
With table selected the Pie Chart has Filter / Highlight / off - It was on Highlight, i have now set to filter,
With Pie Chart selected the table has Filter / off - it was set to Filter
What im asking the filter to do is when a colum is selected in the pie chart show all entries from another column that have a date in the selcted column, and from what im finding i dont think that is possible?
for example, sample data list
| ClockNo | Skill1 | Skill2 |
| 10010 | 10/01/2020 | |
| 10020 | 15/01/2022 | 18/03/2021 |
| 10030 | 05/04/2022 |
Select 'Skill2' in PieChart will show '10020' & '10030' in the table, filtering out '10010'
- v-easonf-msft
Community Support
Hi, CPC-Keith
Yes, there is no button ‘Highlight’ in the table when you edit interactions.
It's currently difficult to make similar highlighting impossible for a table/matrix when you use a pie chart to filter the data.
Best Regards,
Community Support Team _ Eason
