# Implement bidirectional cross-filtering in perspective

**URL:** <https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635>\
**Category:** Ignition Early Access\
**Created:** [August 6, 2021, 9:19am UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635 "2021-08-06T09:19:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [August 6, 2021, 9:19am UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/1 "2021-08-06T09:19:54Z")

</div>

Hi  
I’d like to create some dahaboard pages in perspective like power BI which has bidirectional cross-filtering.

This means each time user click on a pie/bar chart data item, base on the selected item on that chart, the data is filtered for other tables and charts and vice versa.

Unlike table component which has a event component for selected cell, the bar chart (XY chart) and pie chart doesn’t have any sort of event to detect which item is clicked by user.

Using component general mouse click event that read user mouse X Y coordinate to determine which item user click, is not working because the items move and replace base on the dataset and responsive nature if chart.

Thanks for any idea or workaround for this problem.

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 6, 2021, 2:01pm UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/2 "2021-08-06T14:01:21Z")

</div>

Which item is clicked? you could use the labels for that instead of the values?  
also there are a lot of xy values in those events, im sure you could make it responsive with a bit of math

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [August 6, 2021, 2:12pm UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/3 "2021-08-06T14:12:56Z")

</div>

The data is change in each query and vary its place especially for pie chart. It is impossible to get its location dynamically without any sort of event.

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 6, 2021, 2:21pm UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/4 "2021-08-06T14:21:33Z")

</div>

nah im sure its possible. Events ofc would be easier tho

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [August 6, 2021, 2:23pm UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/5 "2021-08-06T14:23:28Z")

</div>

Can you show a simple view to see how to do that?

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [August 6, 2021, 2:24pm UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/6 "2021-08-06T14:24:22Z")

</div>

Not right now, maybe next week

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [August 7, 2021, 6:39am UTC](https://forum.inductiveautomation.com/t/implement-bidirectional-cross-filtering-in-perspective/49635/7 "2021-08-07T06:39:30Z")

</div>

This feature is added in last nightly. Thank you, IA dev team, for the very quick response.

**248: XYChart and Pie Chart: adding a selected items**  
A new property “selection” has been added to the XY Chart and the Pie Chart components. When enabled, the selection property allows the user to select specific slices, bullets, or columns on their respective chart that is reflected in the selection.data read-only sub property.
