Forum Discussion
Filter table by chart
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?
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#M607150
1 Reply
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#M607150