Filter data table using chart

[Anonymous]

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.

[v-danhe-msft]

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

[Anonymous]

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?

[v-danhe-msft]

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

[v-danhe-msft · Accepted solution]

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