Forum Discussion
Filter data table using chart
Hi Anonymous ,
Based on my test, it could work by modifying the reports visual interactions:
You could refer to below link:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Regards,
Daniel He
Hi Anonymous ,
Could you have checked if the different tables have created relationships? Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
It's a very simple dataset and dashboard, just not working as expected.
Dataset:
| Date | Produce | Number in Stock | Number on Order | Number Sold |
| 2/1/2019 | Apple | 300 | 100 | 500 |
| 2/1/2019 | Mango | 30 | 50 | 25 |
| 2/1/2019 | Oranges | 400 | 30 | 120 |
| 2/8/2019 | Apple | 400 | 0 | 0 |
| 2/8/2019 | Mango | 60 | 0 | 20 |
| 2/8/2019 | Oranges | 370 | 200 | 150 |
| 2/15/2019 | Apple | 250 | 150 | 150 |
| 2/15/2019 | Mango | 20 | 100 | 20 |
| 2/15/2019 | Oranges | 350 | 120 | 70 |
Dashboard has 2 visuals: Clustered Bar Chart on top that shows totals for quantities by date and Table on the bottom that shows all lines from dataset.
Once I click on specific line in the table, chart dynamically changes to highlight portions of bars that numbers make up, but if I click on the bar in the chart, table does not change at all. Anyone know how to fix this or what am I doing wrong?
Hi Anonymous ,
Based on my test, it could work by modifying the reports visual interactions:
You could refer to below link:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Regards,
Daniel He
Hi Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He