Forum Discussion
Interactions between two visuals only for selceted column
Hi maflingo
Thanks for the reply from ray_aramburo .
If I understand correctly, you need to filter the Line chart with the table visual that shows the most recent month. According to my test, my suggestion is to add a Slicer to filter the Line Chart. The following test is for your reference.
Select the Slicer visualization and place the domain column into "Field".
Cancel the interaction of the Slicer visual object with the Table visual object to avoid affecting the display of the table.
Select Slicer -> Format -> Edit interactions -> Select None in the upper right corner of the Table table
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do you have any sample of your data so I can reproduce your scenario?
Sure, here you go 🙂
| domain | month | average_score |
| air-up.com | 2024-09-01 00:00:00 | 39.84173 |
| air-up.com | 2024-10-01 00:00:00 | 39.68574 |
| air-up.com | 2024-11-01 00:00:00 | 29.56533 |
| air-up.com | 2024-12-01 00:00:00 | 42.78474 |
| amorelie.de | 2024-09-01 00:00:00 | 51.56147 |
| amorelie.de | 2024-10-01 00:00:00 | 37.26164 |
| amorelie.de | 2024-11-01 00:00:00 | 50.02691 |
| amorelie.de | 2024-12-01 00:00:00 | 63.16355 |
Hi maflingo
Thanks for the reply from ray_aramburo .
If I understand correctly, you need to filter the Line chart with the table visual that shows the most recent month. According to my test, my suggestion is to add a Slicer to filter the Line Chart. The following test is for your reference.
Select the Slicer visualization and place the domain column into "Field".
Cancel the interaction of the Slicer visual object with the Table visual object to avoid affecting the display of the table.
Select Slicer -> Format -> Edit interactions -> Select None in the upper right corner of the Table table
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yulia, I do have a slicer that performs the filtering as you described, but in addition to that, I want to filter from the table. But it's only a matter of convenience, if there isn't a way to do this, then I'll just have to settle for filtering only through the slicer. Thanks!
Hi maflingo
After testing, filtering from the original table doesn't achieve this effect, and another table needs to be created to do so. In my opinion, this method is not as good as using a slicer. But I still write the test procedure below for your reference:
1. Create a calculated table as follows
Table 2 = VALUES('Table'[domain])2. Create a measure as follows
Measure = IF(SELECTEDVALUE('Table 2'[domain]) = BLANK(), 1, IF(MAX('Table'[domain]) = SELECTEDVALUE('Table 2'[domain]), 1, 0))3. Put the measure into the visual-level filters, set up show items when the value is 1.
It's worth mentioning that here you need to put the domain field of Table1 into Legend.
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.