Forum Discussion
Pie chart to filter table
I have a pie chart has around 20 'Skills' as values and shows a count of users with the skill,
The data is coming from a sharepoint list where each employee's clock No is a row with dates when a skill (column) was obtained
I have added a table to the page showing 'Clock No' as the only column
If i select a clock no in the table the pie chart filters to highlight skills that employee has,
How ever it is not working back the other way - if i select a skill in the pie chart the table is not filtered to only show employee clock no's with the skill
Do i need to adjust the setup of the pie chart or the table and what?
I have tested adding skills as filters to the table but this is not working
Thank You
3 Replies
- amitchandak
Super User
CPC-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
