Linking a table to a chart

[zamboni1199]

Hi - I have a report of data I'm presenting.  Underneath it, I've a added a chart to reflect that same data.  When I add a filter to the report on top, the chart below does not get automatically updated with that filter too.

Is there a way to link the two so that a change to the report above is reflected in the chart below?

Thank you.

[slschmitt]

Hello - 

Did you set up a relationship between the tables? 

[zamboni1199]

Thank you.  It's one table of data with a visual underneath it.  Is there a way to set up a relationship between the tabular data above and the visual below it?

[slschmitt]

So click on the filter and go to Format > Edit Interactions. On the visuals, select the Filter icon in the top right.  This will tell the visuals to filter each other and interact with each other when you filter. 

[zamboni1199]

Hi thanks for your time slschmitt.  I figured it out.

[zamboni1199 · Accepted solution]

Ok, the solution was pretty obvious but I just missed it.  When I set up my filter, I mistakenly set it for "Filter on this Visual", which filtered the table data only.  By changing the filter to "Filter on this Page" it filtered both the table and the visual underneath it on the same page. 

[v-yiruan-msft]

Hi @zamboni1199 ,

It's glad to hear that you find the solution to your problem. Could you please share your solution and mark your post as Answered if you are willing to? And it will help the others find the solution easily if they face the same problem with yours. Thank you.

Best Regards

[zamboni1199]

Thank you.  I know I'm not doing something right.  I have the table data filtered by year (>= 2021).  I then clicked on Edit Interactions, clicked on my visual and clicked on the filter icon.  Nothing happened.  I still have 2019, 2020, and 2021 data in the visual.  Perhaps you can right click on the image below and "Open in New Tab" to view it.  Thanks.