Forum Discussion
Filter data table using chart
We have one table with transactional data. We added a clustered chart and a table to a dashboard. Source table contains (for example) date, produce (apple, kiwi, mango...), number in stock, number on order, number sold. Data is the source table is summarized by date/produce. The chart visual shows bars that represent sum of numbers by date. The table visual has 5 columns: date, produce, number in stock, number on order, number sold. When we click on any line in the table, the chart changes to highlight that data as well as table highlights selected row. The problem is when we click on the bars in the chart, the selected bar is highlighted, but the table does not change to highlight specific data for that bar. What are we doing wrong? If it matters, we are using Power BI Desktop only at this point.
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
4 Replies
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