Filter table by chart

[martysk]

Hi guys,

Im new to PBI and im kinda stuck with filtering data using donut chart. What I want to achieve is when I click on donut chart, it will filter and display data in the table. For some reason, it doesnt work.

It works only when I add column "Name" to the legend in donut chart, which I dont want to.

Any idea how to do it, please?

[NickolajJessen · Accepted solution]

Hi, you'll want to look unto unpivoting you data in Power Query. You'll want to get 3 column with Name, Food, Value

For future post please refer to this thread:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...